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.
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?
Hi Tove,
I would like to have the sorting of string IDs like Shop Order, DOP Header, DOP Order, Operation Block, etc. to be ordered as number if the number is numeric.
If there would be a page where the ID sequence, initital ID could be defined, like starting with 2, total length 6, padding a leading character, sorting would work as expected.
Unfortunately I have not found any view / page where these IDs can be defined.
Is IFS working at least on one of this kind of usability improvements?
Thanks for your feedback.
BR Holger
Hi Holger,
This is not something that I know that my group is working on. I would recommend you to add it as an idea (https://community.ifs.com/ideas) that way it will be handled by product management and it will be visible that this is a need.
Best regards
Tove
Thanks, Done, please vote:
Sorting of alphanumeric text ID fields - treat numbers as number
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.