I'm querying a report from ARIS a list of process names and their descriptions.
The process names has alphanumerical ID in front of the actual name such as "C.1.0.1.2 Process A". I want the report to return the list of processes with correct ID order, i.e., C.1.1.1.1 followed by C.1.1.1.2, etc. The sorting by name option in the report is working mostly fine until the last digit becomes double digits as shown below
- C.2.3.3.1
- C.2.3.3.10
- C.2.3.3.2
- C.2.3.3.3
- C.2.3.3.4
- C.2.3.3.5
- C.2.3.3.6
- C.2.3.3.7
- C.2.3.3.8
- C.2.3.3.9
The last digit 10 (the second row) is supposed to be last but it is not. Unfortunately, I cannot also find the option to sort by X or Y axis in the option dropdown list.
Is there a way to sort the list to correct order without changing the format of the last digit to 2 digit structure, i.e., changing 1 to 01?
Martin Schröder on
Hello Soe,
if you use the built-in methods of the WYSIWYG scripting assistant you cannot change the sorting algorithm. In your case you get an alphabetical order of object names, which works as designed, but does not count for the meaning (to humans) of numbers as part of the string.
If you want to sort functions by sequence of the process flow you can apply it on object occurences only (s. this post )
Regards, Martin