You should probably use the DateRange predicate for this: http://dev.day.com/docs/en/cq/current/javadoc/com/day/cq/search/eval/DateRangePredicateEva luator.html
Also, if type is dam:Asset, you probably don't need to specify a path of /content/dam.
Hi Justin ,
Thank you for the response.
I did use date range to get the nodes created on 2013-07-25 as in
This does not fetch the nodes created exactly on 2013-07-25 00:00:00
In simple words , this searches for nodes created > "2013-07-25 00:00:00" .
Please let me know if we have a possibility for searching >= "date" instead of > "date".
I dont want to use relativedaterange because it assumes all months have 30 days .
I would also like to know if there is a possibility for searching in a path except a particular node.
(eg) i want to check for all the assets in the node /content/dam except /content/dam/folder1/folder2 .
This is covered in the documentation I linked to above.
The negative path operation you are describing is not possible using the existing predicates. You could do it with a custom predicate or (possibly better) setting a property on the nodes you want to exclude and using the property predicate with the not operation.
I want to get the list which has cq:replicatation date either null or less than jcr:modifiedDate.
Can you provide your thoughts on this.
You'll probably need to do that through node iteration - JCR Query doesn't support property comparison against another property, only against a static value.