Given following screen, the purchase requisition id is a text field and when you sort it, it sorts it alphabetical but you actually want it to sort it numerical. Are there any workaround / tips / hints how we could make this sorting more user friendly? Seems in the page designer you cannot change the field type or so.
+13
Even though this is not very helpful, in IEE client, it is possible to use Advanced Search SQL Order By to achieve this with using TO_NUMBER(Requisition_No)
Can we do something similar in OData using $orderby?
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
