topic Re: RE: How sort collection by multiple fields in Product Forum

How sort collection by multiple fields

vinodchinthakin — Fri, 28 Oct 2022 05:33:00 GMT

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
------------------------------

RE: How sort collection by multiple fields

Carl__Carter — Fri, 28 Oct 2022 07:20:00 GMT

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
------------------------------

RE: How sort collection by multiple fields

vinodchinthakin — Fri, 28 Oct 2022 07:30:00 GMT

Thanks Carl, It's worked excellent.!

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

Re: RE: How sort collection by multiple fields

pmittal — Mon, 27 May 2024 15:45:25 GMT

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

Re: RE: How sort collection by multiple fields

MichealCharron — Mon, 27 May 2024 20:50:02 GMT

@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.

Re: RE: How sort collection by multiple fields

harshithaakumar — Fri, 14 Mar 2025 12:27:33 GMT

This worked like a Charm! Thank you.