How to add multiple paths in Querybuilder query. | Community
Skip to main content
A
akshaybhujbale
Level 6
September 8, 2022
Solved

How to add multiple paths in Querybuilder query.

  • September 8, 2022
  • 2 replies
  • 981 views

hi

type=dam:Asset
group.1_daterange.property=jcr:content/jcr:lastModified
group.1_daterange.lowerBound=2022-09-05T01:00:00.000
group.1_daterange.upperBound=2022-09-09T18:00:00.000
group.2_daterange.property=jcr:created
group.2_daterange.lowerBound=2022-09-05T01:00:00.000
group.2_daterange.upperBound=2022-09-09T18:00:00.000
group.p.or=true
group.1_group.path=/content/dam/closedaclcheck
group.2_group.path=/content/dam/we-retail
group.p.or=true
p.limit=-1

 

I have added multiple paths as above but getting wrong results.

 

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 ksh_ingole7

Hi @akshaybhujbale 

 

type=dam:Asset
group.1_daterange.property=jcr:content
group.1_daterange.lowerBound=2021-09-05T01:00:00.000
group.1_daterange.upperBound=2022-09-09T18:00:00.000
group.2_daterange.property=jcr:created
group.2_daterange.lowerBound=2021-09-05T01:00:00.000
group.2_daterange.upperBound=2022-09-09T18:00:00.000
group.p.or=true
0_group.1_group.1_path=/content/dam/path1
0_group.2_group.2_path=content/dam/path2
0_group.p.or=true
p.limit=-1

 

 

 

 

This query worked for me. Kindly try and let me know. 

 

 

 

 

 

 

Thanks

2 replies

ksh_ingole7
Community Advisor
ksh_ingole7Community AdvisorAccepted solution
Community Advisor
September 8, 2022

Hi @akshaybhujbale 

 

type=dam:Asset
group.1_daterange.property=jcr:content
group.1_daterange.lowerBound=2021-09-05T01:00:00.000
group.1_daterange.upperBound=2022-09-09T18:00:00.000
group.2_daterange.property=jcr:created
group.2_daterange.lowerBound=2021-09-05T01:00:00.000
group.2_daterange.upperBound=2022-09-09T18:00:00.000
group.p.or=true
0_group.1_group.1_path=/content/dam/path1
0_group.2_group.2_path=content/dam/path2
0_group.p.or=true
p.limit=-1

 

 

 

 

This query worked for me. Kindly try and let me know. 

 

 

 

 

 

 

Thanks

    A
    akshaybhujbaleAuthor
    Level 6
    September 8, 2022

    Hi @ksh_ingole7 

    THis is working but giving wrong results

      milind_bachani
      Adobe Employee
      milind_bachaniAdobe Employee
      Adobe Employee
      September 8, 2022

      Hi @akshaybhujbale ,

       

      Can you explain the use case for which you are framing the query ? Which can help advisors to have better understanding of the underlying requirement and can help with options.

       

      Thanks

        A
        akshaybhujbaleAuthor
        Level 6
        September 8, 2022

        Hi @milind_bachani 

        ype=dam:Asset
        group.1_daterange.property=jcr:content/jcr:lastModified
        group.1_daterange.lowerBound=2022-09-05T01:00:00.000
        group.1_daterange.upperBound=2022-09-09T18:00:00.000
        group.2_daterange.property= 
        group.2_daterange.lowerBound=2022-09-05T01:00:00.000
        group.2_daterange.upperBound=2022-09-09T18:00:00.000
        group.p.or=true
        group.1_group.path=/content/dam/closedaclcheck
        group.2_group.path=/content/dam/we-retail
        group.p.or=true
        p.limit=-1

         

        I want to add multiple paths to above query to get jcr:content/jcr:lastModified and jcr:created between specified dates

         

          milind_bachani
          Adobe Employee
          milind_bachaniAdobe Employee
          Adobe Employee
          September 8, 2022

          @akshaybhujbale  Just to explain you the query written above would be returning :

          the assets under path /content/dam/closedaclcheck whose jcr:content/jcr:lastModified is between 5th - 9th Septemeber

          OR

          the assets under path /content/dam/we-retail whose jcr:created is between 5th - 9th September

          Is that what you are trying to achieve?

            Terms & ConditionsAccessibility statement

            Loading footer...