Support Article
Sorting does not work on Listview when custom activity is used
SA-2203
Summary
User runs a list view and tries to perform sorting on columns ‘.pyID’, ‘.DocName’. Below are observations:
- When user clicks on ‘.pyID’ column to sort task id entries, the pop-up appears stating that sorting cannot be performed on this column.
- When user clicks on ‘.DocName’, sorting does not get performed correctly.
Error Messages
NA
Steps to Reproduce
1) Create list view report.
2) Drag few fields (which includes ‘.pyID’ and any other custom property say '.DocName' which uses custom format) for display and enable sorting on all the fields.
3) Run the list view report and click on each column to perform sorting.
Root Cause
Pagination (‘All Pages’ mode) is enabled for the reported list view. In this case the property being sorted on, must not have any functions overriding the way its sorted on. Property ‘.pyID’ has a function defined for overriding sorting. Hence this column is not supported for performing sorting.
For ‘.DocName’ column, user has customized the format which will re-set the values displayed on the screen. As the sorting and filtering functionalities will work based on the original values saved in the database and not according to the format values displayed on the screen, sorting ‘.DocName’ will not display the column values in sorted order on screen.
Resolution
To perform sorting as expected on ‘.pyId’ column, user has to either reset the pagination mode to ‘Viewed Page’ or function defined for overriding sorting should be removed. For ‘.DocName’ column, the custom format has to be removed, so that original values displays on the screen and then sorting the '.DocName' column displays column values in sorted order.
Published January 31, 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.