I have a query as below:
From this result I need to filter whose
registrationCompletedDate or jcr:createdDate value is greater than 5 days Both these properties are of type Date.
Can you help how I need to modify the query ? Do we have any property to get the dte greater than a particular value?
You can make use of predicate named "relativedaterange" to achieve this.
Below is the sample query. (To get all assets that are modified 5 days before)
relativedaterange.lowerBound=-5d (If no upperBound is specified, it is treated as 0, indicating current time)
If any Date property which is in future like say eventDate and to get all events that will happen in next 5 days, then the query will be like
relativedaterange.upperBound=5d (If no lowerBound is specified, it is treated as 0, indicating current time)
Other options in detail about this predicate in below link
Try something as below
Even you can use daterange instead of relativedaterange.