Support Article
Sorting on pyID is incorrect
SA-22961
Summary
When a column is sorted on pyID, the sort is incorrect. For example, ID-100 is sorted as if it were smaller than ID-99.
Error Messages
Not Applicable
Steps to Reproduce
Sort a column by pyID.
Root Cause
Work IDs are generally built as a combination of Text and Number with '-' separator and as a whole treated as a Text String. As a result, the numeric part of the ID does not determine the sort order.
Resolution
Perform the following local-changes:
- Refer to the PDN article using the link given below.
- Create another property in Assign- class in a custom rule set and update this property value with the value of pxRefObjectInsName by iterating through the list. This property can be configured in the grid for the sortable row. Specify a custom sort function, which can be used for sorting.
Published May 14, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.