topic Re: Query latest publications in Alfresco Archive

Query latest publications

kweilbacher — Fri, 04 Feb 2011 20:16:34 GMT

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!

Re: Query latest publications

bremmington — Tue, 08 Feb 2011 08:10:51 GMT

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
‍‍‍

Re: Query latest publications

ben — Tue, 08 Feb 2011 08:15:54 GMT

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/.

Re: Query latest publications

kweilbacher — Tue, 08 Feb 2011 22:44:21 GMT

Thanks for the fast response!