Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Query Builder - Search multiple properties with AND/OR operator

Avatar

Avatar
Level 1
troubleshooter3
Level 1

Likes

0 likes

Total Posts

14 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
troubleshooter3
Level 1

Likes

0 likes

Total Posts

14 posts

Correct Reply

0 solutions
View profile
troubleshooter3
Level 1

24-08-2020

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

View Entire Topic

Avatar

Avatar
Establish
MVP
Nupur_Jain
MVP

Likes

165 likes

Total Posts

186 posts

Correct Reply

76 solutions
Top badges earned
Establish
Ignite 1
Give Back 5
Give Back 3
Give Back 25
View profile

Avatar
Establish
MVP
Nupur_Jain
MVP

Likes

165 likes

Total Posts

186 posts

Correct Reply

76 solutions
Top badges earned
Establish
Ignite 1
Give Back 5
Give Back 3
Give Back 25
View profile
Nupur_Jain
MVP

24-08-2020

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