Expand my Community achievements bar.

July 31st AEM Gems Webinar: Elevate your AEM development to master the integration of private GitHub repositories within AEM Cloud Manager.
SOLVED

AEM 6.5.8 and 6.5.12- Querybuilder -Group daterange and path

Avatar

Level 10

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

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

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 -

DEBAL_DAS_0-1655192241407.png

 

View solution in original post

6 Replies

Avatar

Community Advisor

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.

 

Avatar

Level 10

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 

 

Avatar

Correct answer by
Employee Advisor

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 -

DEBAL_DAS_0-1655192241407.png

 

Avatar

Community Advisor

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


Arun Patidar