Within Service Manager, There are a number of records that consume a number record for their key .
However if that key contains a prefix or a suffix the sort order within the view is not numerical.
e.g. List will display as:
Is there a way we can actually force a numerical sort without adding another field?
- Could this be added to a further version?
I hope you are talking about qbe list views of records. If that is correct, then you can make the Table columns clickable by selecting checkbox "Clickable Title" to true in the corresponding qbe FD.
Probably wasn't clear enough, they already are clickable, just the order is alphabetical vs numerical.
So for anything using a number record and you attempt a sort of the primary key it's not a numerical sequence, it's alphabetical, which annoys a large chunk of our customers as the "Last Page" isn't the last records or first records submitted it's just whatever came last or first in the alphabetical order.
For me it is not the same. Are you able to replicate this across all modules? See the attached screenshots and you shall have an understanding on my previous reply. We make the columns clickable only to sort the ID's.
Sure can replicate it,
Happens on Change, Request, Request Task, Incident and Problem all sorting on number
Bog standard request task view.
Nothing in the logs, no errors in the UI, this query was just "true", we're running 9.62.
- happens in all queries.
I don't think Support will be able to assist much as developers will come back with, "This is by design" and has been this way since the beginning.
Sort for alphanumeric value will always sort by alpha and not by number.
Since the new enhancement process is more transparent and driven by customer demand. Best avenue would be the Ideas Exchange.
You could submit an Idea at https://community.softwaregrp.com/t5/SMA-Idea-Exchange/idb-p/SMA-X-Ideas to ask that the sort be enhanced to break the value to 2 parts: suffix and numbers and sort only by the numbers.
I am sure a lot of the members here will vote for it. I have seen this complain in a few incarnations of helpdesk softwares. Maybe with enough support/push from the community, we can finally get the sorting "redesigned" to work better. You will have my vote.
If you ended here due to your users complaints, please help vote for redesign of the sort in Service Manager here, https://community.microfocus.com/t5/SMA-Idea-Exchange/Primary-Key-sort-numerically-instead-of-alphabetically-for/idc-p/2703442#M3426