Our vBulletin migration is complete.
Welcome vBulletin users! All content and user information from the Micro Focus Forums (vBulletin) site has been migrated to this site. READ MORE.
Highlighted
Honored Contributor.. Ivis Honored Contributor..
Honored Contributor..
631 views

Incident.id sort when you go from SD99999 to SD100000

How do you sort when the number exceedes? 

Now SD99999 is coming after SD100000 because it is a char and it will se SD100000 as the lower number then SD99999 -> anyone faced this issue? 

I found a KM that says you could sort on open.time but that could influence performance. 

Any other ideas? 

Thanks! 

BR Ivis. 

Tags (1)
0 Likes
3 Replies
ALARMus Acclaimed Contributor.
Acclaimed Contributor.

Re: Incident.id sort when you go from SD99999 to SD100000

You can try to add one or more zero digit like this SD0099999, SD0100000.

Edit file named NUMBER by setting new value in length field (for incidents). Also need to rename all existing interaction incident.id - add zeros after prefix - SD

0 Likes
Honored Contributor.. Ivis Honored Contributor..
Honored Contributor..

Re: Incident.id sort when you go from SD99999 to SD100000

Will this not alter all the id's? SD0099999 is not the same as SD99999. I.e all references will not work anymore. Relations between tickets must be altered in screlate etc. Sounds massive and not a good approach.
0 Likes
ALARMus Acclaimed Contributor.
Acclaimed Contributor.

Re: Incident.id sort when you go from SD99999 to SD100000

of course it is necessary to consider all the places where contains the old number to change it everywhere.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.