Sort By Ticket Tag

V5 Question
1

I made a ticket lister using the widget. Also I have set my own Order No using the Ticket Tags. How can I sort these tickets by Ticket Tag?

Another question is how can I filter to show only ticket total greater than 0?

Thank you

Screenshot_1
Screenshot_11596×685 73.5 KB

2

I don’t think you can sort by tag. But you need to use document status for sums greater than 0

3

Samba.Presentation_cKYPt94H0m
Samba.Presentation_cKYPt94H0m947×905 15.1 KB

4

You must write your ticket tag name to order by area.

5

Actually I did and I think it is sorting but not properly. It is sorting as below:
1
100
101
2
3

Any idea how to fix that?

Thank you

6

you must tag tickets like 001,002,003,…

7

Or try to convert ticcket tag to numeric. with TN code.

8

How exactly I can tag as numeric? My code is {:ORDERNUMBER} for tagging. Thanks a lot in advance

9

That is typical numerical sorting by computers, think if it was letters rather than numbers. Would forder by 1st char first then seccond.

10

Try setting tag using something like;
[=F(’{:ORDERNUMBER}’,’###’)]

11

Thank you. Works like a charm!

12

Unfortunately this still give me trouble when sorting.I will end this here since I have this same topic somewhere else. Thank you.