Sorting Additional Data with specific values | Community
Skip to main content
Level 2
July 18, 2022
Question

Sorting Additional Data with specific values

  • July 18, 2022
  • 0 replies
  • 523 views

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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.