Query Builder - Search multiple properties with AND/OR operator

Question

How can I search with in multiple properties using OR operator. Below is what I need:

path=/test/12

1_property=property1

1_property.value=value1

AND

2_property=property2

2_property.value=value2

OR

3_property=property3

3_property.value=value3

1st property is mandatory while 2nd and 3rd is OR

Nupur_Jain · Accepted Answer

Hi @troubleshooter3

Your Query builder query should look like this

path=/test/12
1_property=property1
1_property.value=value1
group.p.or=true
group.2_property=property2
group.2_property.value=value2
group.3_property=property3
group.3_property.value=value3

if I am able to understand your requirment correctly. The above query should return path where property1 should be equal to value1 and either of the other two properties must be same as given value i.e property2=value2 or property3=value3.

Hope it helps!

Thanks!

Nupur

Sign up

Login with SSO

Login to the community

Login with SSO