How do I get only a certain Order State value in Reports?

V5 Question
1

image
image1600×900 79.1 KB

I only want to see “Gift Nora” in the Application Subtitle. How should I format the report tag?

Right now, it’s {REPORT ORDER STATES}, but that shows all States.

I’ve tried
{REPORT ORDER DETAILS:OS.Gift}
{REPORT ORDER DETAILS:OS.Gift:Nora}
{REPORT ORDER DETAILS:OSV.Gift}
{REPORT ORDER DETAILS:OSV.Gift:Nora}
but they don’t show anything

2

If using Report order details you need to define a field.
{REPORT ORDER DETAILS:O.Total:(OS.Status=Gift)} would filter Total field from orders that have a state Gift of Status.

You can see more of how to use report tags in kb.sambapos.com reports section.

3

Thanks for the reply Jesse.

Looking at the docs, I figured that
{REPORT ORDER DETAILS:O.Quantity.Sum:(OS=Gift)}
will show me the total count of Gifted orders, but how do I reduce it down to a certain Gift Reason?

image
image1920×1080 128 KB

Edit:
I’ve tried

{REPORT ORDER DETAILS:O.Quantity.Sum:(OS=Gift.Nora)}
{REPORT ORDER DETAILS:O.Quantity.Sum:(OS=Gift:Nora)}
{REPORT ORDER DETAILS:O.Quantity.Sum:(OS=Gift Nora)}
{REPORT ORDER DETAILS:O.Quantity.Sum:(OSV=Nora)}
4

Not at pc but of top of my head try OSV.

5

I tried

{REPORT ORDER DETAILS:O.Quantity.Sum:(OSV=Nora)}
{REPORT ORDER DETAILS:O.Quantity.Sum:(OSV=Gift:Nora)}
{REPORT ORDER DETAILS:O.Quantity.Sum:(OSV=Gift.Nora)}
{REPORT ORDER DETAILS:O.Quantity.Sum:(OSV=Gift Nora)}

as well.

6

That is a Command Value… Are you storing that command value in the state somewhere? If not you would need too.

There is another way to reference that if you are using the latest version of sambapos. We now record ACM Users and Values.

Here is an example of how it is used. You may have access to it with REPORT ORDER DETAILS but I know for a fact Ticket details works.

image

7

When you press Nora where in the state is it storing that? It looks like you are not storing that in the state.

8

Technically it would be (OSV.GStatus=Nora) If you are using default gift state.

9

image
image696×188 6.55 KB

Oh, I was under the assumption the value “Nora” was being stored as an Order State Value.

It’s being stored under the default Gift ACM Button.

This still returns empty.
{REPORT ORDER DETAILS:O.Quantity.Sum:(OSV.GStatus=Nora)}

10

What is the actual state? Default its GStatus

11

The Order State is Gift:Nora

12

Ok sorry I asked wrong… what is your State Name. Gift:Nora is State and State Value
But you need to know State Name too

13

Is it default like:

image

14

I’m think it’s GStatus, but let me check.

15

image
image691×554 15.2 KB

image

16

Did you try:

{REPORT ORDER DETAILS:O.Quantity.Sum:(OSV.GStatus=Gift:Nora)}

17

Doesn’t work either :sob: