How sort collection by multiple fields

[vinodchinthakin]

Hi All , Any one can suggest how to Sort Collection for Multiple conditions. For Example Filed1 needs to be Sorted as "Ascending" and Filed2 needs to be Sorted as "Descending" at once. I was able to achieve in Excel(which is called as Custom Sort). How to apply Custom Sorting in BP Collection?

Thanks​​

------------------------------
vinod chinthakindi
------------------------------

[Carl__Carter · Accepted solution]

Hi Vinod,

You can copy the Sort action in the 'Utility - Collection' business object into a new Action.

Once done, delete the Ascending Order action input and data item, as these are not required for the new action.

Adjust the code start to match the below:


When you call the Action, the [Sort Field] Input Parameter would list the fields to sort by and their order. Each field separated by a comma. For example:

[FieldName1] ASC, [FieldName2] DESC


------------------------------
Carl Carter
Senior Developer
Blue Prism
Europe/London
------------------------------

[vinodchinthakin]

Thanks Carl, It's worked excellent.!

------------------------------
vinod chinthakindi
------------------------------

[pmittal]

Hi
Can you share complete start, end, code properties for this?

[MichealCharron]

@pmittal 

There is a little trick to turn the Sort Collection action in Blue Prism's Utility - Collection Manipulation VBO into a multi-column sorter. You simply list out your columns and their sort directions separated by a comma but leave out the sort direction of the last column. Set the Ascending Order parameter accordingly to the sort direction of that last column.

The Sort Collection action does essentially the same thing as the code in the replies above but it adds either " ASC" or " DESC" to the Sort Field string depending on how the Ascending Order parameter is set.