How to sort a text field (which contains numbers) as numbers and not alpabetical

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?

@Tove Ståhl :

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

Hi, 

I have the same issue. If there is no better way to solve it then  I think I will create CustomField that contains converted value, e.g: cf_num_rel_no = to_number(rel_no). (rel_no is string)

Then you can define “Order by” in PageDesigner.

Any way, I will vote for you idea.

Br. Barbara