AEM 6.5.8 and 6.5.12- Querybuilder -Group daterange and path | Community
Skip to main content
N
NitroHazeDev
Level 9
June 13, 2022
Solved

AEM 6.5.8 and 6.5.12- Querybuilder -Group daterange and path

  • June 13, 2022
  • 6 replies
  • 1125 views

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.
Best answer by DEBAL_DAS

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 -

 

6 replies

N
NitroHazeDevAuthor
Level 9
June 13, 2022

Anyone please?

    ShaileshBassi
    Community Advisor
    ShaileshBassiCommunity Advisor
    Community Advisor
    June 14, 2022

    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.

     

      N
      NitroHazeDevAuthor
      Level 9
      June 14, 2022

      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
        DEBAL_DASAccepted solution
        New Member
        June 14, 2022

        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
          arunpatidar
          Community Advisor
          arunpatidarCommunity Advisor
          Community Advisor
          June 14, 2022

          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
            N
            NitroHazeDevAuthor
            Level 9
            June 14, 2022

            Thanks @debal_das @arunpatidar .!! 

              Terms & ConditionsAccessibility statement

              Loading footer...