After running query output is not coming

Avatar

Avatar

sunitac2231600

Avatar

sunitac2231600

sunitac2231600

14-04-2016

Dear Team,

I am following below document to run my query.

https://docs.adobe.com/docs/en/cq/5-6-1/dam/customizing_and_extendingcq5dam/query_builder. html

When I want to look into the last modify pages change , by using below query

Find all pages and order them by last modified

     
1

2

type=cq:Page
orderby=@jcr:content/cq:lastModified

 

 

Then I am getting below error.

 

java.text.ParseException: Query: type=(*)cq:Page orderby=@jcr:content/cq:lastModified; expected:

 

I have attached the screenshot of error also.

 

Replies

Avatar

Avatar

CQ_learner

Avatar

CQ_learner

CQ_learner

14-04-2016

Hi,

For XPath Query in crx you can use the following syntax to get the pages ordered by cq:lastmodified.

/jcr:root/content//element(*, cq:Page)
order by cq:lastModified

Please refer the following documentation for more info.

https://docs.adobe.com/docs/en/cq/5-6-1/dam/customizing_and_extendingcq5dam/query_builder.html

Avatar

Avatar

kautuk_sahni

Community Manager

Total Posts

5.6K

Likes

1.0K

Correct Reply

1.1K

Avatar

kautuk_sahni

Community Manager

Total Posts

5.6K

Likes

1.0K

Correct Reply

1.1K
kautuk_sahni
Community Manager

19-04-2016

Hi 

Please use following query:-

/jcr:root/content/geometrixx/en//element(*, cq:Page)
order by jcr:content/@cq:lastModified

I would suggest you to use this tool:-

Link:- http://localhost:4502/libs/cq/search/content/querydebug.html

 

Top Reference article to read:- http://aemcq5.blogspot.in/2014/11/cq5-querybuilder-simplified.html

 

I hope this would help you.

Thanks and Regards

Kautuk Sahni