Sort Page list based on two criteria
Hi,
I have a issue where I need to sort a Page List with two criteria. Putting the below example to illustrate the issue.
Say, I have a page list X which contains apart from other number of properties, one dropdown property with three values namely A, B and C in each page of the X page list. It also has a Decimal property in each page of X page list. Now the requirement is to sort the page list based on above two properties where for the drop down values page should be sorted first in the order B, A, C (i.e. pages with B selected will be at the top followed by A and C) and then on previously sorted list the decimal property should be sorted in decreasing order.
Please let me know how to solve this issue at the earliest.
Thanks for your help in advance.
Accepted Solution
Pegasystems Inc.
US
Hi,
I don't believe there is any single OOTB function to achieve this.
You can use the following method to get the expected result.
- Create three page lists from the main page list, first containing the pages that have B checked and the next with A checked and next with C checked.
- Now sort the three page lists individually based on the decimal property.
- After the individual sorting is done, you can append the above three lists to a new page list(you can do this in any order you wish) and copy that page list back to the original one.
Hope this helps.
--Ravi
StaidLogic
IN
Hi Anirvan,
If the number of results fetched from report are less then you can use pre-activity to load page list with data in grid and follow below method to get details in required sorting order.
-Create a Report definition with all required output and Drop Down property as filter condition (which will be passed as parameter). Define sorting on decimal property
-Create an activity to call above report definition 3 times by passing parameter values in the order B, A, C.
- After each report run append the results to a page list.
This page list can be the source for grid configuration.
If the results are more and need to use pagination to fetch specified number of records at a time, you can use below approach.
-OOTB sorting will not be able to sort the details as B, A, C.
-Create a new property and define declare expression to assign value based on drop down values
example: B -> 1 , A -> 2 and C -> 3
- Use this property for sorting the results.
Hope it helps.
Thanks,
Ananda Bhat