Office Hours Homework - Entity OR filtering

Community
1

@Stephen_K_ojwang I hope this helps you filter your entities via AND / OR. If it doesn't, can you describe the problem you are trying to solve?

The file shows both choice list filtering as well as instance lookup filtering versions

Entity ANDOR filtering.xlsx (225.3 KB)

4 Likes
2

Wow, thanks alot. The placement of ‘or’ operator is now clear to me on this calculation: instance('ENTITYLISTNAME')/root/item[field1='value1' or field2='value2']/name)

I was being tempted to separate the computation and join them using the ‘or’ though have not tried to valid this:

instance('ENTITYLISTNAME')/root/item[field1='value1']/name) or instance('ENTITYLISTNAME')/root/item[field2='value2']/name)

2 Likes