New Participant

Query to fetch Assets where jcr:content/metadata/jcr:lastModified is greater than jcr:content/cq:lastReplicated

Hi All,

I need to fetch the assets where "jcr:content/metadata/jcr:lastModified is greater than jcr:content/cq:lastReplicated".

Is it possible to compare to two metadata values while querying. Please help me in writing the query for this scenario.

So far I am aware is the daterange predicate which is querying a metadata date property against a specific date.

Thanks,

Selva

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

New Participant

Did you able to solve the issue?

Thanks,

Pradeep

New Participant

I don't think so we can compare dynamic operand with another dynamic operand but static values

DynamicOperand Operator StaticOperand

you can try to write simple servlet to achieve this, without writing queries or use Sling Queries instead of JCR queries.

Arun Patidar

New Participant

I would look at using JCR SQL2 to perform this type of query:

Sign up