CQL: how to order documents by title (description,author...)

serverok — Thu, 17 Sep 2009 16:23:49 GMT

Hi All,I have the question:how can I order the Documents by Title (cm:title), Description (cm:description), Author (cm:author), etc. in CQL?for example, this code works greatELECT D.* FROM Document AS D ORDER BY D.Name‍BUTELECT D.* FROM Document AS D ORDER BY D.Title‍orSELECT D.* FROM Document A

Re: CQL: how to order documents by title (description,author...)

jpotts — Thu, 05 Jul 2012 18:36:45 GMT

Old post, but in case it helps someone, the title and description are defined in an aspect. CMIS 1.0 doesn't support aspects natively but Alfresco implements support for aspects through joins. So here is how you'd find all documents with a name like *test* ordered by their description:

select d.*,t.* from cmis:document as d join cm:titled as t on d.cmisbjectId = t.cmisbjectId where d.cmis:name like '%test%' order by t.cm:description

Jeff

topic CQL: how to order documents by title (description,author...) in Alfresco Archive

CQL: how to order documents by title (description,author...)

Re: CQL: how to order documents by title (description,author...)