Solved How sort collection by multiple fields

mbailey

Member
Is there a way to sort a collection by multiple columns? For example, if I have a collection with first name and last name fields and I want it sorted by last name and then first name to ensure that Allen Jones appears before Tom Jones, how can I do that?
 

VJR

Well-Known Member
Hi mbailey,

If Field2 is the Last Name and Field3 is the First Name column then try giving the below in the 'Sort Field' parameter of the 'Sort Collection' action.

"Field2, Field3"

Perhaps this would resolve your issue but you may not have the chance in a situation to sort one field in ascending and the other in descending when both are given at once as above.
 

mbailey

Member
VJR,

Thanks - that solved my problem. The VBO documentation is singular (Sort Field, The field to sort by) and there was absolutely no indication that a comma delimited list could be used.
 

Gitanjali

New Member
I have to sort my collection which contains covid cases per day, by having the highest cases on the top. what should I do to sort one particular field in descending order in blue prism?
 
Top