AEM 6.5.8 and 6.5.12- Querybuilder -Group daterange and path | Community
Skip to main content
N
NitroHazeDev
New Participant
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
New Participant
June 14, 2022

Thanks @debal_das @arunpatidar .!! 

    arunpatidar
    arunpatidar
    New Participant
    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
      DEBAL_DAS
      DEBAL_DASAccepted solution
      New Participant
      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 -

       

        N
        NitroHazeDevAuthor
        New Participant
        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 

         

          ShaileshBassi
          ShaileshBassi
          New Participant
          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
            New Participant
            June 13, 2022

            Anyone please?

              Terms & ConditionsAccessibility statement

              Loading footer...