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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

How to add multiple paths in Querybuilder query.

Avatar

Level 6

hi

type=dam:Asset
group.1_daterange.property=jcr:content/jcr:lastModified
group.1_daterange.lowerBound=2022-09-05T01:00:00.000
group.1_daterange.upperBound=2022-09-09T18:00:00.000
group.2_daterange.property=jcr:created
group.2_daterange.lowerBound=2022-09-05T01:00:00.000
group.2_daterange.upperBound=2022-09-09T18:00:00.000
group.p.or=true
group.1_group.path=/content/dam/closedaclcheck
group.2_group.path=/content/dam/we-retail
group.p.or=true
p.limit=-1

 

I have added multiple paths as above but getting wrong results.

 

1 Accepted Solution

Avatar

Correct answer by
Level 5

Hi @akshaybhujbale 

 

type=dam:Asset
group.1_daterange.property=jcr:content
group.1_daterange.lowerBound=2021-09-05T01:00:00.000
group.1_daterange.upperBound=2022-09-09T18:00:00.000
group.2_daterange.property=jcr:created
group.2_daterange.lowerBound=2021-09-05T01:00:00.000
group.2_daterange.upperBound=2022-09-09T18:00:00.000
group.p.or=true
0_group.1_group.1_path=/content/dam/path1
0_group.2_group.2_path=content/dam/path2
0_group.p.or=true
p.limit=-1

 

 

 

 

This query worked for me. Kindly try and let me know. 

 

 

 

ksh_ingole7_1-1662639431218.png

 

 

 

Thanks

View solution in original post

5 Replies

Avatar

Correct answer by
Level 5

Hi @akshaybhujbale 

 

type=dam:Asset
group.1_daterange.property=jcr:content
group.1_daterange.lowerBound=2021-09-05T01:00:00.000
group.1_daterange.upperBound=2022-09-09T18:00:00.000
group.2_daterange.property=jcr:created
group.2_daterange.lowerBound=2021-09-05T01:00:00.000
group.2_daterange.upperBound=2022-09-09T18:00:00.000
group.p.or=true
0_group.1_group.1_path=/content/dam/path1
0_group.2_group.2_path=content/dam/path2
0_group.p.or=true
p.limit=-1

 

 

 

 

This query worked for me. Kindly try and let me know. 

 

 

 

ksh_ingole7_1-1662639431218.png

 

 

 

Thanks

Avatar

Employee Advisor

Hi @akshaybhujbale ,

 

Can you explain the use case for which you are framing the query ? Which can help advisors to have better understanding of the underlying requirement and can help with options.

 

Thanks

Avatar

Level 6

Hi @milind_bachani 

ype=dam:Asset
group.1_daterange.property=jcr:content/jcr:lastModified
group.1_daterange.lowerBound=2022-09-05T01:00:00.000
group.1_daterange.upperBound=2022-09-09T18:00:00.000
group.2_daterange.property= 
group.2_daterange.lowerBound=2022-09-05T01:00:00.000
group.2_daterange.upperBound=2022-09-09T18:00:00.000
group.p.or=true
group.1_group.path=/content/dam/closedaclcheck
group.2_group.path=/content/dam/we-retail
group.p.or=true
p.limit=-1

 

I want to add multiple paths to above query to get jcr:content/jcr:lastModified and jcr:created between specified dates

 

Avatar

Employee Advisor

@akshaybhujbale  Just to explain you the query written above would be returning :

the assets under path /content/dam/closedaclcheck whose jcr:content/jcr:lastModified is between 5th - 9th Septemeber

OR

the assets under path /content/dam/we-retail whose jcr:created is between 5th - 9th September

Is that what you are trying to achieve?