QueryBuilder - multiple daterange properties

Deepikaa_Nagesh

02-06-2020

Hi,

 

Is it possible to give a regex pattern for a daterange.property in aem query builder and search for all properties falling under the regex pattern.

 

Usecase :  we are trying to query around 30 date properties set for an asset whether if any particular date among them falls under the given date range.

 

Thanks,

Deepikaa

 

querybuilder
View Entire Topic

Ankur_Khare

MVP

02-06-2020

Did u check this- using groovy script

 

  • daterange : This predicate is used to search a date property range.
    • daterange.property : Specify a property which is searched.
    • daterange.lowerBound :  Fix a lower bound eg. 2010-07-25
    • daterange.lowerOperation : “>” (default) or “>=”
    • daterange.upperBound:  Fix a lower bound eg. 2013-07-26
    • daterange.upperOperation: “<” (default) or “<=”
  • relativedaterange: It is an extension of daterange which uses relative offsets to server time. It also supports 1s 2m 3h 4d 5w 6M 7y
    • relativedaterange.lowerBound : Lower bound offset, default=0
    • relativedaterange.upperBound : Upper bound Offset .
path=/home/users type=rep:User
group.1_daterange.property=jcr:created group.1_daterange.lowerBound=2014-08-18 group.1_daterange.upperBound=2014-08-19
group.2_daterange.property=cq:lastModified group.2_daterange.lowerBound=2014-08-18 group.2_daterange.upperBound=2014-08-19
group.p.or=true