Hi Team
I have a requirement where i need to execute query to retrieve the below data.
Query Equivalent:-
Select page_url, published_datw,title,tags,(both on the Basic tab), content_type, content_format, category, sub-categories, article_read_time, (all on the Article Properties tab) secondary_meta_keywords, noindex, nofollow.
I have run the below query but its only gave page path, name, title and last modified date and created date but i want published date too that's why added property=@jcr:content/cq:lastReplicated.
Regards
Seema Kumari
Solved! Go to Solution.
Views
Replies
Total Likes
Hi,
try with query like below
type=cq:Page path=/content/we-retail/us/en/products/equipment/running orderby.sort=desc orderby=@jcr:content/jcr:title p.hits=selective p.properties=jcr:path jcr:content/jcr:title jcr:content/cq:lastReplicated p.limit=-1
Respectively to above query builder servlet path
Hi @skumari1 ,
What you're looking for is technically a report .
And then you can add a query in the report and get the desired fields:
https://adobe-consulting-services.github.io/acs-aem-commons/features/report-builder/index.html
After clicking on the link given in the doc i.e, /etc/acs-commons/reports.html
It's giving 404 error. Do I need to install any package to open this console?
Regards
Seema Kumari
Yes. You would need acs-commons.
https://adobe-consulting-services.github.io/acs-aem-commons/
Hi @skumari1 ,
If you are looking for a report as @Anmol_Bhardwaj mentioned, yes you need to have acs-commons to instance.
(you can download the package or add a dependency to your project for ACS Commons, check this link: https://github.com/Adobe-Consulting-Services/acs-aem-commons/releases )
But if you are looking to retrieving the date for development purpose, you might need write a sling model where you can retrieve all the above mentioned data either through a value map or through query builder API.
Thanks,
Sravan
Hi,
try with query like below
type=cq:Page path=/content/we-retail/us/en/products/equipment/running orderby.sort=desc orderby=@jcr:content/jcr:title p.hits=selective p.properties=jcr:path jcr:content/jcr:title jcr:content/cq:lastReplicated p.limit=-1
Respectively to above query builder servlet path