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 Member
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 -

 

Debal Das, Senior AEM Consultant
View in thread

6 replies

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

Anyone please?

Translate
    ShaileshBassi
    Community Advisor
    ShaileshBassiCommunity Advisor
    Community Advisor
    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 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
        DEBAL_DAS
        DEBAL_DASAccepted solution
        New Member
        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
        Debal Das, Senior AEM Consultant
          arunpatidar
          Community Advisor
          arunpatidarCommunity Advisor
          Community Advisor
          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
            NitroHazeDevAuthor
            Level 9
            Jun 14, 2022 12:59 PM UTC

            Thanks @debal_das @arunpatidar .!! 

            Translate
              Terms & ConditionsAccessibility statement

              Loading footer...