5 Replies Latest reply: Jul 25, 2013 1:03 PM by Justin Edelson

How to create a query in for lastModifiedDate in Query Builder

HarishDv Jul 24, 2013 9:41 AM

I want to create a query to get the Dam Assets those with their lastModifiedDate that match the current date.

The usual lastmodified date is of the format yyyy-MM-ddThh:mm:ss etc.

With the current date we only have "yyyy-MM-dd"

I tried something like this ,

map.put("path","/content/dam");

map.put("type","dam:Asset");

map.put("property","cq:lastModified");

map.put("property.value","yyyy-MM-dd*"); / map.put("property.value","yyyy-MM-dd~"); / map.put("property.value","yyyy-MM-dd");

But i was not able to get the desired results.

Please suggest if there is a a way to do it if you have already tried anything similar .

Thanks in advance

Harish

1. Re: How to create a query in for lastModifiedDate in Query Builder

Justin Edelson Jul 24, 2013 10:10 AM (in response to HarishDv)

Hi Harish-
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.

Justin
Like Show 0 Likes (0)

Actions
2. Re: How to create a query in for lastModifiedDate in Query Builder

HarishDv Jul 25, 2013 4:04 AM (in response to Justin Edelson)

Hi Justin ,

Thank you for the response.

I did use date range to get the nodes created on 2013-07-25 as in

map.put("daterange.lowerBound", "2013-07-25");
map.put("daterange.upperBound", "2013-07-26");

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 .

Harish
Like Show 0 Likes (0)

Actions
3. Re: How to create a query in for lastModifiedDate in Query Builder

Justin Edelson Jul 25, 2013 5:48 AM (in response to HarishDv)

Hi Harish,
This is covered in the documentation I linked to above.

map.put("daterange.lowerOperation", ">=");

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.

Justin
Like Show 0 Likes (0)

Actions
4. Re: How to create a query in for lastModifiedDate in Query Builder

maruthid Jul 25, 2013 11:12 AM (in response to Justin Edelson)

Hi Justin,

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.
Like Show 0 Likes (0)

Actions
5. Re: How to create a query in for lastModifiedDate in Query Builder

Justin Edelson Jul 25, 2013 1:03 PM (in response to maruthid)

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.
Like Show 0 Likes (0)

Actions

Go to original post

How to create a query in for lastModifiedDate in Query Builder

1. Re: How to create a query in for lastModifiedDate in Query Builder

2. Re: How to create a query in for lastModifiedDate in Query Builder

3. Re: How to create a query in for lastModifiedDate in Query Builder

4. Re: How to create a query in for lastModifiedDate in Query Builder

5. Re: How to create a query in for lastModifiedDate in Query Builder

Actions

More Like This

Legend