Multiple OR , (AND+OR) conditions in the Filter/Lookup functions

Feedback Apps
, ,
1

Hello,

I’ve had at least 3 instances, one of which was a question posed to me by one of my YouTube audience .

How to write multiple OR conditions using the Apps Filter function?

For now, I have suggested that the following options be tried

For multiple OR conditions:

Or(Filter(Conditon1), Filter(Condition2))

And for a combination of AND and OR conditions:

Or(Filter(Conditon1, Condition2), Filter(Condition3))

Can you kindly confirm if these work?
If not, is there a plan in the roadmap to add such a feature to UiPath App functions?

It would be really helpful to have this feature to incorporate multiple OR , (AND, OR) conditions in the Filter (and also Lookup) functions.

Thanks!

cc: @evan.cohen

3

Hey @AndyMenon

Kindly refer this - Function: And, Or, Not

Thanks
#nK

4

Sorry @Nithinkrishna ,

I’m not sure what is it I’m missing here. But I’m talking about Filter/Lookup conditions that run data queries on the backend Data Service.

Or([a=b],[c=d])

may be markedly different from how this works

Or(Filter(Data Service Query1), Filter(Data Service Query 2))

In the latter case, we are executing queries that OR’s two Data Sets not simple switches.

Trying to clarify what I just stated. Here is the Filter function documentation page and this is the example shown on that page:

image
image880×118 4.49 KB

What if I want to select records that are from New York or Los Angeles?

Do I write it like this?

Or(Filter(Customer, [City,"=",New York]), Filter(Customer, [City,"=",Los Angeles]))

Or, is there a better/easier way?

Theoretically, can I write it like this (or does UiPath plan to add this in the future)?

Filter(Customer, [City, "in", New York || Los Angeles])

P.S. It was on my schedule to try this out sometime, but haven’t gotten to it yet.

Thanks,
Andy

5

Hello @AndyMenon ,

We tried same approach in past to filter data based on multiple AND/OR condition but I think this is not possible at the moment. Rights now you can either write one condition. But I believe this is into road map to allow for multiple operator filter into a condition.

Cheers.

Thanks,
Arvind

1 Like
6

Thanks @Arvind_Kumar1 ,

Good to know you have tried this out. I think the other way is to somehow get the second column from Entity2 to be part of Entity 1 and reduce the condition down to a single expression.

Thanks for getting back to us. :slightly_smiling_face: