Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.
SOLVED

How to add multiple paths in Querybuilder query.

Avatar

Level 7

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
Community Advisor

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
Community Advisor

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 7

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?