topic How to query categories with CMIS in Alfresco Archive

How to query categories with CMIS

evoci — Thu, 12 Feb 2015 09:41:58 GMT

I have a Alfresco Community 5.0a repository, and would like to retrieve categories uid starting from their name using java and OpenCmis (alfresco-opencmis-extension-0.7.jar).I try to executeItemIterable<QueryResult> results = session.query("SELECT * FROM cm:category", false);‍‍‍but Alfresco lo

Re: How to query categories with CMIS

mrogers — Thu, 12 Feb 2015 10:09:21 GMT

If you use the cmis 1.1 endpoints then the query will work. No need for the extension.

However its not that simple since you will be looking up the category rather than the nodes with that category. I think you can do it with two lookups with CMIS 1.1 IIRC Jeff Potts looked at this in his first review of Alfresco's CMIS 1.1.

Re: How to query categories with CMIS

evoci — Thu, 12 Feb 2015 15:06:55 GMT

Got it, thanks.
Can you recommend a way for retrieving children of a category better than querying


SELECT cmis:objectId,cmis:name,alfcmis:nodeRef FROM cm:category C WHERE CONTAINS(C, 'PATH:\"/cm:generalclassifiable/cm:"
                  + categoryName + "/*\"')
‍‍‍‍

Re: How to query categories with CMIS

mrogers — Thu, 12 Feb 2015 15:31:10 GMT

I think you can search by CATEGORY. Certainly the Categories and TAGS are in the index.

Re: How to query categories with CMIS

vizziello — Wed, 16 Mar 2016 17:43:20 GMT

Hi,

you could use a POST request to get all information that you need.

Try with this query:

SELECT * FROM cm:category C WHERE CONTAINS(C, 'PATH:\"/cm:generalclassifiable//[CATEGORY-NAME]\"')

This is an example for category "Giurisprudenza":

http://localhost:8080/alfresco/api/-default-/public/cmis/versions/1.1/browser/?cmisaction=query&statement=SELECT%20*%20FROM%20cm:category%20C%20WHERE%20CONTAINS(C,%20%27PATH:%22/cm:generalclassifiable//cm:Giurisprudenza%22%27)

Best regards,
Giuseppe.