- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
30-06-20 08:04 AM
Is it possible to apply filter on a collection on two different coulmns at the same time using the single query. I have to filter one column & based on those results i want to filter another column, just like how we do manually in an excel. Is it possible via single query or I need to perform it in two different steps.
------------------------------
sapna soni
.
Capgemini Pvt Ltd
Asia/Kolkata
------------------------------
Answered! Go to Answer.
Helpful Answers
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
14-07-20 11:47 PM
So, for the multiple sort actions... I think we're talking about the same thing here. If we're not, then I'll take it all back! 😃 Anyway, if you were trying to sort on 3 columns of a collection, you produce the same end result by sorting the collection 3 separate times but in reverse order. So, you could compare it to an Excel sort on multiple columns. There, you might tell Excel that you want to sort on multiple columns in this order: Field1, Field2, Field3. It would put alphabetical/numerical order preference on Field1, and then the next preference/sort on Field2, and then the next on Field3. In Blue Prism, if you were to do the same thing by sorting on Field1 then Field2 then Field3 with three separate action calls to Sort Collection, it would mess up your results. You'd just need to reverse it. So you sort by Field3 then Field2 then Field1, and you get the same results as if you were to use the way you found by doing Sort Collection with a field input of 'Field1,Field2,Field3'.
------------------------------
Dave Morris
Cano Ai
Atlanta, GA
------------------------------
Dave Morris, 3Ci at Southern Company
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
30-06-20 08:35 AM
You can filter them using a single action using the AND Operator
"[Column1] Like 'Criteria1' AND [Column2] Like 'Criteria2'"
------------------------------
Rajath Gopal
Associate IT Consultant
ITC Infotech
Asia/Kolkata
8904867411
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
30-06-20 08:42 AM
We can filter multiple columns by adding the AND/OR between each selection Criteria.
"[Col A] = 'Data1' AND [Col B] = 'Data2' "
Regards,
NP
------------------------------
Nitin Prakash
Associate Cunsultant
Symphony Ventures
Asia/Kolkata
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-07-20 08:34 PM
------------------------------
Jenna Schnizlein
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
13-07-20 07:05 AM
For sorting collection with any number of tiers, you can use below expression.
"[Field1]='Value' AND [Field2]='Value' AND [Field3]='Value'"
(Note: If space exists in any column name you need to use [ ] to sort correctly).
You can include 'n' number of different fields to sorting values.
Please let me know if you are not clear.
Regards,
------------------------------
Yeswa Vaibhav Alwar Nerella
Associate Consultant
Capgemini
Asia/Kolkata
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
13-07-20 01:42 PM
------------------------------
Jenna Schnizlein
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
13-07-20 05:57 PM
Anyway, I should have known that was a thing. I just never tried it. Thanks!
------------------------------
Dave Morris
Cano Ai
Atlanta, GA
------------------------------
Dave Morris, 3Ci at Southern Company
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
14-07-20 11:51 AM
I would be interested to hear about how you got the multiple sort actions to work properly. I'm not sure how to message you directly though, so that we can breakout that conversation.
------------------------------
Jenna Schnizlein
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
14-07-20 11:47 PM
So, for the multiple sort actions... I think we're talking about the same thing here. If we're not, then I'll take it all back! 😃 Anyway, if you were trying to sort on 3 columns of a collection, you produce the same end result by sorting the collection 3 separate times but in reverse order. So, you could compare it to an Excel sort on multiple columns. There, you might tell Excel that you want to sort on multiple columns in this order: Field1, Field2, Field3. It would put alphabetical/numerical order preference on Field1, and then the next preference/sort on Field2, and then the next on Field3. In Blue Prism, if you were to do the same thing by sorting on Field1 then Field2 then Field3 with three separate action calls to Sort Collection, it would mess up your results. You'd just need to reverse it. So you sort by Field3 then Field2 then Field1, and you get the same results as if you were to use the way you found by doing Sort Collection with a field input of 'Field1,Field2,Field3'.
------------------------------
Dave Morris
Cano Ai
Atlanta, GA
------------------------------
Dave Morris, 3Ci at Southern Company
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
27-10-22 01:18 PM
Any one can suggest here.
Thanks
------------------------------
vinod chinthakindi
------------------------------
