Sort sort ascending & sort descending is not working as expected on Manage Work Order UI
Hi,
When we reach the max count/threshold of 9999 after Work order prefix, sort descending sorts the work order I guess based on the nuber right after work order prefix 9 in this case and for sort ascending it takes 1 into consideration, Ideally it should consider the entire number after Prefix.
We have work orders created after WO_HFD9999, lets say WO_HFD_100031 is the latest work order,sort descending should show it first but it shows WO_HFD9999 instead which is confusing.
To See the latest work order WO_HFD_100031 we have to use sort ascending but it shows everything that starts with WO_HFD 1000 and not the latest one, for the latest one again we have to scroll. ( I know we can use start date as a work around) but the sorting on work order number isnt working correctly.