topic Re: CMIS query for unique values in a property in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/cmis-query-for-unique-values-in-a-property/m-p/263529#M216659 <HTML><HEAD></HEAD><BODY><SPAN>Neither select distinct nor group by is supported by the CMIS specification. So it isn't really a limitation of the product–if it were in the spec we'd have to implement it. I suppose the best you can do is an order by and then iterate over the results, maintaining your own distinct list.</SPAN><BR /><BR /><SPAN>Jeff</SPAN></BODY></HTML> Mon, 24 Sep 2012 19:54:22 GMT jpotts 2012-09-24T19:54:22Z CMIS query for unique values in a property https://connect.hyland.com/t5/alfresco-archive/cmis-query-for-unique-values-in-a-property/m-p/263528#M216658 Can I use CMIS to query for the unique property values of an object type? Can I use the distinct or group by clause?eg: select distinct cmis:name from dl:dataList OR select cmis:name from dl:dataList group by cmis:nameIf not, what is the alternate in Alfresco because doing this outside Alfresco will Mon, 24 Sep 2012 06:04:20 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-query-for-unique-values-in-a-property/m-p/263528#M216658 varun33 2012-09-24T06:04:20Z Re: CMIS query for unique values in a property https://connect.hyland.com/t5/alfresco-archive/cmis-query-for-unique-values-in-a-property/m-p/263529#M216659 <HTML><HEAD></HEAD><BODY><SPAN>Neither select distinct nor group by is supported by the CMIS specification. So it isn't really a limitation of the product–if it were in the spec we'd have to implement it. I suppose the best you can do is an order by and then iterate over the results, maintaining your own distinct list.</SPAN><BR /><BR /><SPAN>Jeff</SPAN></BODY></HTML> Mon, 24 Sep 2012 19:54:22 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-query-for-unique-values-in-a-property/m-p/263529#M216659 jpotts 2012-09-24T19:54:22Z