Expand my Community achievements bar.

Sorting Additional Data with specific values

Avatar

Level 2

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!

0 Replies