Query latest publications

[kweilbacher]

On the default Quick Start home page the right side displays a list of recent blogs. I would like to replace that with a list of recently updated documents from the publication folder. Need assistance on setting up the propery query string. Thanks in advance!

[bremmington]

The asset collection that you're referring to is the one named "blogs.latest" in the root section of the website. The query in this asset collection is:

select d.* from cmis:document as d where in_tree(d, '${section:/blog}') and d.cmis:objectTypeId='D:ws:article' and d.cmis:name not like 'comment-thankyou.html' order by d.cmis:creationDate desc
‍‍‍

To change this so that it returns the latest publications you might want something like:

select d.* from cmis:document as d where in_tree(d, '${section:/publications}') and d.cmis:objectTypeId='D:ws:article' order by d.cmis:creationDate desc
‍‍‍

[ben]

Just FYI, you may find the documentation useful here also - see Configuring a dynamic asset collection here http://www.alfresco.com/help/34/community/wcmqs/user/.

[kweilbacher]

Thanks for the fast response!