Sorting orders in ticket printer template

V5 Question
2

I am still struggling to get this working…

The states that I have (in order of added to ticket are):

  • 20190403
  • 20190401
  • 20190403

I would like the orders to be sorted in alpha/numerical/chronological order:

  • 20190401
  • 20190403

If I update by [ORDERS GROUP|] then I can add a manual sort order and the output is how I would expect. (Note I am now using “Document Printer” notation for the various advantages @markjw ourlined.

[ORDERS GROUP|ORDER STATE:BookingDate:20190401,20190403]
<TableRow><TableCell Padding="0,10,0,0" ColumnSpan="3">{CALL:tkt2.dateHeader('{GROUP KEY}')}</TableCell></TableRow>

Of course I cannot manually add these numbers, so I started thinking about how I could produce the ordered list of states to feed in to the [ORDERS GROUP|] and I came up with the following:

{REPORT ORDER DETAILS:OS.BookingDate.asc:T.Id={TICKET ID}::,}

This works perfectly and will create a CSV list of BookingDates anywhere within my printer template, however when I add this CSV to the [ORDERS GROUP|] definition it seems to have now effect whatsoever.

Any ideas where I might be going wrong?