AEM 6.5.8 and 6.5.12- Querybuilder -Group daterange and path | Community
Skip to main content
NitroHazeDev
Level 9
Jun 13, 2022 8:18 PM UTC
Solved

AEM 6.5.8 and 6.5.12- Querybuilder -Group daterange and path

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
DEBAL_DAS
DEBAL_DASAccepted solution
New Participant
Jun 14, 2022 7:28 AM UTC

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 -

 

View reply

6 replies

NitroHazeDevAuthor
Level 9
Jun 14, 2022 12:59 PM UTC

Thanks @debal_das @arunpatidar .!! 

Translate
    arunpatidar
    arunpatidar
    New Participant
    Jun 14, 2022 7:53 AM UTC

    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
    Translate
    Arun Patidar
      DEBAL_DAS
      DEBAL_DASAccepted solution
      New Participant
      Jun 14, 2022 7:28 AM UTC

      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 -

       

      Translate
        NitroHazeDevAuthor
        Level 9
        Jun 14, 2022 5:00 AM UTC

        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 

         

        Translate
          ShaileshBassi
          ShaileshBassi
          New Participant
          Jun 14, 2022 4:56 AM UTC

          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.

           

          Translate
            NitroHazeDevAuthor
            Level 9
            Jun 13, 2022 8:56 PM UTC

            Anyone please?

            Translate
              Terms & ConditionsAccessibility statement

              Loading footer...