AEM 6.5.8 and 6.5.12- Querybuilder -Group daterange and path

[NitroHazeDev]

Is it possible to do a grouping of paths and date range?

type=dam:Asset
group.1_path=/content/dam/test/Y

group.1_daterange.property=jcr:created
group.1_daterange.upperBound=2022-06-12
group.2_path=/content/dam/test/X
group.2_daterange.upperBound=2022-06-13
group.2_daterange.property=jcr:created
group.p.or=true

p.limit =-1

@arunpatidar @VeenaVikraman @DEBAL_DAS

[NitroHazeDev]

Anyone please?

[ShaileshBassi]

The issue looks like with "group.1_path".

If you try to run the query without the group.1_path, then in that case the correct results will be displayed.

[NitroHazeDev]

thanks for your response @ShaileshBassi I agree but could not use it cause  it defeats the purpose since the requirement is to query across groupings of path and date range 

[DEBAL_DAS · Accepted solution]

Could you please try with below query and let me know the result -

type=dam:Asset
group.p.or=true
group.1_group.path=/content/dam/we-retail/en/products
group.1_group.1_daterange.property=jcr:created
group.1_group.1_daterange.upperBound=2022-06-12
group.2_group.path=/content/dam/we-retail/en/people
group.2_group.1_daterange.property=jcr:created
group.2_group.1_daterange.upperBound=2022-06-12
p.limit =-1

I have tested it on AEM 6.5.12 -

[arunpatidar]

Hi,

This is possible

group.1_group.type=dam:Asset
group.1_group.path=/content/dam/test/Y
group.1_group.daterange.property=jcr:created
group.1_group.daterange.upperBound=2022-06-12


group.2_group.type=dam:Asset
group.2_group.path=/content/dam/test/X
group.2_group.daterange.property=jcr:created
group.2_group.daterange.upperBound=2022-06-13

group.p.or=true

[NitroHazeDev]

Thanks @DEBAL_DAS @arunpatidar .!!