How to add multiple paths in Querybuilder query.

[akshaybhujbale]

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.

[ksh_ingole7 · Accepted solution]

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. 

Thanks

[akshaybhujbale]

Hi @ksh_ingole7 

THis is working but giving wrong results

[milind_bachani]

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

[akshaybhujbale]

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

[milind_bachani]

@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?