I am trying query list in workflow, to get the record having the maximum value , the field is a single line text field.
The normal descending and ascending is not working. Getting the below sequence. Tried the collection sort also., didn't work
18007;
18007;
180060;
18006;
18006;
180059;
18005;
18005
Is there a way to sort it like
180060
180059
18007
... etc