I have a query where I am assigning invoice information to a collection of 1 in Additional Data. I want to sort on specific enumerated values that can't be sorted naturally. IE. I want to sort in this order: '3' is 1st, '4' is 2nd, '2' is 3rd, remainder is 4th
I tried programming an additional field in my collection data and sorting on that but either the programming is wrong or you can't sort on a programmed field.
Thanks!