I have to return a table data based on a column sorting. it is pretty much simple.
problem is that sorting column is a Enum Type and AX saves its int value in db & i have to sort on its Label value.
what i found so far is to “add a view on table, add a column with Enum label, then sort on View data”
but in this case i creating a view just for sorting purpose. which is not a good solution when are working on big product
Is there is any other quick solution for this?