# Order Tag Details

**URL:** <https://forum.sambapos.com/t/order-tag-details/19355>\
**Category:** V5 Question\
**Created:** [February 12, 2019, 1:47am UTC](https://forum.sambapos.com/t/order-tag-details/19355 "2019-02-12T01:47:15Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Posflow](https://forum.sambapos.com/user_avatar/forum.sambapos.com/posflow/32/63001_2.png) [@Posflow](https://forum.sambapos.com/u/Posflow)\
**Post date:** [February 12, 2019, 1:47am UTC](https://forum.sambapos.com/t/order-tag-details/19355/1 "2019-02-12T01:47:15Z")

</div>

I have a really silly question here haha…

Ive never done Order Tag reports but I have a client that wants a really basic listing of it. I decided just use

```auto
@{REPORT ORDER TAG DETAILS:T.Name:(ODI=True):{0}:,}
[$1 Tag Report:1,1,1,1]
{REPORT ORDER TAG DETAILS:T.Value,T.Qty,T.Price:T.Name="$1"} 

```

but it doesnt really list anything.

I havent had my coffee yet so I am not sure what I am missing

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [February 12, 2019, 1:49am UTC](https://forum.sambapos.com/t/order-tag-details/19355/2 "2019-02-12T01:49:48Z")

</div>

Move the parameter under report name section them add T.Name to a column. Then do T.Qty.sum

---

<div class="post-metadata">

**Author:** ![Posflow](https://forum.sambapos.com/user_avatar/forum.sambapos.com/posflow/32/63001_2.png) [@Posflow](https://forum.sambapos.com/u/Posflow)\
**Post date:** [February 12, 2019, 2:01am UTC](https://forum.sambapos.com/t/order-tag-details/19355/3 "2019-02-12T02:01:30Z")

</div>

```
[$1 Tag Report:1,1,1,1]
@{REPORT ORDER TAG DETAILS:T.Name:(ODI=True):{0}:,}
{REPORT ORDER TAG DETAILS:T.Name,T.Qty.sum,T.Value,T.Price:T.Name="$1"}

```

Like this? Can listing even be under the [$1 Tag Report] ?😅  
No effect, I am sure I am missing something very basic here…

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [February 12, 2019, 2:02am UTC](https://forum.sambapos.com/t/order-tag-details/19355/4 "2019-02-12T02:02:20Z")

</div>

I’m not at a terminal but no remove the $1 in the name make it static. I’ll get to computer and test.

---

<div class="post-metadata">

**Author:** ![Posflow](https://forum.sambapos.com/user_avatar/forum.sambapos.com/posflow/32/63001_2.png) [@Posflow](https://forum.sambapos.com/u/Posflow)\
**Post date:** [February 12, 2019, 2:06am UTC](https://forum.sambapos.com/t/order-tag-details/19355/5 "2019-02-12T02:06:27Z")

</div>

Making the name static and putting $1 below lists the Order Tag Group Names correctly but it doesnt list its values nor quantities. 😄

 ![image](https://forum.sambapos.com/uploads/default/original/3X/6/b/6b178a3d342373c0ea74d25d25749241248ba0ed.png)

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [February 12, 2019, 2:08am UTC](https://forum.sambapos.com/t/order-tag-details/19355/6 "2019-02-12T02:08:00Z")

</div>

the T.Name ="$1" is wrong. Remove that see what happens.

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [February 12, 2019, 2:08am UTC](https://forum.sambapos.com/t/order-tag-details/19355/7 "2019-02-12T02:08:30Z")

</div>

Try this:

```auto
[Order Tag Report:1,1,1,1]
{REPORT ORDER TAG DETAILS:T.Name,T.Qty.sum,T.Value,T.Price}

```

We can work on customizing it once we get it working.

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [February 12, 2019, 2:11am UTC](https://forum.sambapos.com/t/order-tag-details/19355/8 "2019-02-12T02:11:30Z")

</div>

```auto
[Order Tag Report:3,1,2,1]
>Group Name|QTY|Tag|Price
{REPORT ORDER TAG DETAILS:T.Name,T.Qty.sum,T.Value,T.Price}

```

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [February 12, 2019, 2:12am UTC](https://forum.sambapos.com/t/order-tag-details/19355/9 "2019-02-12T02:12:40Z")

</div>

Or this will sort it descending from most tags to least.

```auto
[Order Tag Report:3,1,2,1]
>Group Name|QTY|Tag|Price
{REPORT ORDER TAG DETAILS:T.Name,T.Qty.sum.desc,T.Value,T.Price}

```

---

<div class="post-metadata">

**Author:** ![Posflow](https://forum.sambapos.com/user_avatar/forum.sambapos.com/posflow/32/63001_2.png) [@Posflow](https://forum.sambapos.com/u/Posflow)\
**Post date:** [February 12, 2019, 2:12am UTC](https://forum.sambapos.com/t/order-tag-details/19355/10 "2019-02-12T02:12:43Z")

</div>

Yes, removing that works. This is what I get. Also, this is my database not my client’s so there isnt a lot of modifiers.

Works very similar. I just added .asc and $1

 ![image](https://forum.sambapos.com/uploads/default/original/3X/7/a/7a67a9d0293eb9053ee21f7e2f74199a9d01432a.png)

They show up properly but was was hoping I can group them by T.Name like sales report with ItemGroup.

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [February 12, 2019, 2:20am UTC](https://forum.sambapos.com/t/order-tag-details/19355/11 "2019-02-12T02:20:09Z")

</div>

Oh so you mean like this:

```auto
@{REPORT ORDER TAG DETAILS:T.Name:(ODI=True):{0}:,}
[$1 Tag Report:3,1,2,1]
{REPORT ORDER TAG DETAILS:T.Name,T.Qty.sum.desc,T.Value,T.Price:(OT=$1)}

```

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [February 12, 2019, 2:23am UTC](https://forum.sambapos.com/t/order-tag-details/19355/12 "2019-02-12T02:23:13Z")

</div>

Or actually this is better:

```auto
@{REPORT ORDER TAG DETAILS:T.Name:(ODI=True):{0}:,}
[$1 Tag Report:1,2, 1]
{REPORT ORDER TAG DETAILS:T.Qty.sum.desc,T.Value,T.Price:(OT=$1)}

```

---

<div class="post-metadata">

**Author:** ![Posflow](https://forum.sambapos.com/user_avatar/forum.sambapos.com/posflow/32/63001_2.png) [@Posflow](https://forum.sambapos.com/u/Posflow)\
**Post date:** [February 12, 2019, 2:23am UTC](https://forum.sambapos.com/t/order-tag-details/19355/13 "2019-02-12T02:23:52Z")

</div>

> [@Jesse](#):
>
> @{REPORT ORDER TAG DETAILS:T.Name:(ODI=True):{0}:,} [$1 Tag Report:3,1,2,1] {REPORT ORDER TAG DETAILS:T.Name,T.Qty.sum.desc,T.Value,T.Price:(OT=$1)}

Yes, thats exactly what I mean. However, they seem to “interfere” with one another. Because of Custom tags maybe? Could I use O.OrderTags != “Discount” to stop them form listing?

 ![image](https://forum.sambapos.com/uploads/default/original/3X/1/f/1f0f101496a8ff1acf69e1bd9987cef55936fc8a.png)

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [February 12, 2019, 2:24am UTC](https://forum.sambapos.com/t/order-tag-details/19355/14 "2019-02-12T02:24:51Z")

</div>

You can try that and see.

---

<div class="post-metadata">

**Author:** ![Posflow](https://forum.sambapos.com/user_avatar/forum.sambapos.com/posflow/32/63001_2.png) [@Posflow](https://forum.sambapos.com/u/Posflow)\
**Post date:** [February 12, 2019, 2:31am UTC](https://forum.sambapos.com/t/order-tag-details/19355/15 "2019-02-12T02:31:55Z")

</div>

This was supposed to be easy haha…

Both as (OT!=“Discount”) and O.OrderTags != “Discount” dont work as a filter.

Or I am using them wrong.

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [February 12, 2019, 2:32am UTC](https://forum.sambapos.com/t/order-tag-details/19355/16 "2019-02-12T02:32:01Z")

</div>

Weird im not sure why its showing others. It shouldnt.

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [February 12, 2019, 2:34am UTC](https://forum.sambapos.com/t/order-tag-details/19355/17 "2019-02-12T02:34:47Z")

</div>

@emre can you explain this to me.

```auto
@{REPORT ORDER TAG DETAILS:T.Name:(ODI=True):{0}:,}
[$1 Tag Report:1,2, 1]
{REPORT ORDER TAG DETAILS:T.Qty.sum,T.Value,T.Price:(OT=$1)}

```

I have that… it should return each tag under its tagname but its not acting correctly.

I made this report to demonstrate the issue:

```auto
@{REPORT ORDER TAG DETAILS:T.Name:(ODI=True):{0}:,}
[$1 Tag Report:1,1,2, 1]
{REPORT ORDER TAG DETAILS:T.Name,T.Qty.sum,T.Value,T.Price:(OT=$1)}

```

![image](https://forum.sambapos.com/uploads/default/original/3X/2/f/2f6cfe9cde6f1875b4d68fe16c0ce6a5c509248a.png)

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [February 12, 2019, 2:35am UTC](https://forum.sambapos.com/t/order-tag-details/19355/18 "2019-02-12T02:35:30Z")

</div>

Notice name on left… even though I used OT=X it still returned tags from other Tag Names.

---

<div class="post-metadata">

**Author:** ![Posflow](https://forum.sambapos.com/user_avatar/forum.sambapos.com/posflow/32/63001_2.png) [@Posflow](https://forum.sambapos.com/u/Posflow)\
**Post date:** [February 12, 2019, 2:36am UTC](https://forum.sambapos.com/t/order-tag-details/19355/19 "2019-02-12T02:36:53Z")

</div>

Yeah, funny that. I thought it was only mine because I was playing with custom tags the other day.

I wiped all the transactions and start new just to see if maybe something else influenced it. Still the same.

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [February 12, 2019, 2:38am UTC](https://forum.sambapos.com/t/order-tag-details/19355/20 "2019-02-12T02:38:06Z")

</div>

Wait nm I see why… OT is not a real expression its a field. Give me a minute.

[Next page](https://forum.sambapos.com/t/order-tag-details/19355.md?page=2)
