topic Re: Simple CMIS 1.1 search problem in Alfresco Archive

Simple CMIS 1.1 search problem

mangar — Fri, 07 Feb 2014 05:07:29 GMT

I am googleing away and I am sure I am mixing my atompub, cmis 1.0, and cmis 1.1 I am using CMIS 1.1, I have a custom model, and I am trying to get all documents with my custom property value equaling something. My query isELECT cmisbjectId FROM cmis:document D WHERE jis:myProperty = "someText"I

Re: Simple CMIS 1.1 search problem

mrogers — Fri, 07 Feb 2014 14:34:20 GMT

try

select * from cmis:document WHERE jis:myProperty = 'someText'

Re: Simple CMIS 1.1 search problem

mangar — Fri, 07 Feb 2014 16:09:12 GMT

I am getting:
Exception in thread "main" org.apache.chemistry.opencmis.commons.exceptions.CmisInvalidArgumentException: Invalid column for cmis:document.jis:myProperty

I know I have done the modeling correctly, because 1: I used this property when I used CMIS to import the documents, and 2: when I view the properties in explorer they are there. I have no errors in the logs.

Any Ideas?

Re: Simple CMIS 1.1 search problem

mrogers — Fri, 07 Feb 2014 16:35:51 GMT

Sorry just noticed cmis:document wont have your property. You need to use the name of your type.

Perhaps if you posted details of your model then we would be able to answer better.

Re: Simple CMIS 1.1 search problem

jpotts — Fri, 07 Feb 2014 17:00:28 GMT

I assume your custom property belongs to either a custom type or a custom aspect. If it belongs to a custom type, your from needs to include it, so it would be something like:


SELECT cmis:objectId FROM jis:myType WHERE jis:myProperty = "someText"
‍‍‍

However, if your property is defined in an aspect, it would be something like:


SELECT D.cmis:objectId, J.jis:myProperty FROM cmis:document as D join jis:myAspect as J on D.cmis:objectId = J.cmis:objectId where J.jis:myProperty = , jis:myType as J WHERE J.jis:myProperty = "someText"
‍‍‍

The custom content types tutorial has a CMIS section that includes example queries:
http://ecmarchitect.com/alfresco-developer-series-tutorials/content/tutorial/tutorial.html

And the CMIS & Apache Chemistry book has an entire chapter on query syntax:
http://www.manning.com/mueller/

Jeff

Re: Simple CMIS 1.1 search problem

jpotts — Fri, 07 Feb 2014 17:01:33 GMT

Sorry for the duplication, Mark–I didn't see your response until I hit save!

Jeff

Re: Simple CMIS 1.1 search problem

mangar — Fri, 07 Feb 2014 18:18:00 GMT

Thank you both. works great.

Jeff, thanks for the links, that is exactly what I was looking for.