Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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.
          https://pdn.pega.com/support-articles/inconsistency-sorting-functionality-work-objects-id
  • 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.
Suggest Edit

Published May 14, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us