topic Re: Custom Model and CMIS Query in Alfresco Archive

Custom Model and CMIS Query

adolfho — Wed, 22 May 2013 16:50:02 GMT

Hi All, I have a custom model and in types definition I have the following definition:<type name="spurocesso"> <title>Processo</title> <parent>cm:folder</parent> <properties> <property name="spurocesso.Numero"> <title>Número&l

Re: Custom Model and CMIS Query

jpotts — Wed, 22 May 2013 20:11:21 GMT

Go look at the type definition for your custom aspect (using a tool like OpenCMIS Workbench or a client library) and check (1) that the property is queryable and (2) that you are using the query name which could be different than the actual property name. (Especially with your non-alphanumeric character in the property name).

For example, using my SomeCo examples, I can successfully query in the sc:isActive boolean property like this:

<blockcode>
SELECT * FROM cmis:document as D join sc:webable as W on D.cmisbjectId = W.cmisbjectId where W.sc:isActive = true
</blockcode>
Jeff

Re: Custom Model and CMIS Query

adolfho — Fri, 24 May 2013 12:42:56 GMT

Hi Jeff, thank you for your answer but unfortunately we faced this problem after the whole application is already developed and we have to keep the non-alpha character. We are using CONTAINS(P, 'spurocesso.Externo: \'false\'') but is getting slower and now I know it isnt the right function to use once this isnt text to be searched.
Following our model I tried 'P.Externo:isActive' but it didnt work because I have its name as ":spu.processo.Externo" like is showed in the definition I pasted. Do you think there is another way?

Thanks
A.