topic Re: "=" and "IN" operators doesn't work in CMIS query in Alfresco Archive

"=" and "IN" operators doesn't work in CMIS query

aminebarbare — Fri, 07 Oct 2016 09:13:35 GMT

Hi guys,I defined an aspect where the "typeDocument" property is defined : <?xml version="1.0" encoding="UTF-8"?><model name="idoc:ideodocModel" xmlns="http://www.alfresco.org/model/dictionary/1.0"><

Re: "=" and "IN" operators doesn't work in CMIS query

jpotts — Fri, 07 Oct 2016 13:21:35 GMT

You cannot do those comparisons against a string, according to the CMIS spec. When comparing strings, you may only use "=, <>, [NOT] LIKE".

Re: "=" and "IN" operators doesn't work in CMIS query

aminebarbare — Fri, 07 Oct 2016 18:14:23 GMT

Well the thing is that the operators '=' and 'IN()' are not working (the query gets nothing)

I tried combining '>=' and '<=' operators in the same query to get '=' (>= + <= is the same as = "logically") and surprisingly I get the right results from the query.

So i wanna normally use the '=' and 'IN()' in my queries instead of combining '>=' and '<=' or using 'LIKE'.

Re: "=" and "IN" operators doesn't work in CMIS query

jpotts — Fri, 07 Oct 2016 20:14:42 GMT

What CMIS service URL are you using and what are you using to run the query?

Re: "=" and "IN" operators doesn't work in CMIS query

aminebarbare — Mon, 10 Oct 2016 10:55:13 GMT

CMIS service URL : http://localhost:8080/alfresco/api/-default-/public/cmis/versions/1.1/atom

and I'm using

chemistry-opencmis-client-impl

version 0.12.0

Re: "=" and "IN" operators doesn't work in CMIS query

jpotts — Mon, 10 Oct 2016 18:48:44 GMT

Can you share your code?

Re: "=" and "IN" operators doesn't work in CMIS query

jpotts — Mon, 10 Oct 2016 20:28:41 GMT

Using 201605-GA running on Mac OS X with Chemistry 0.12.0 I cannot recreate your problem. I used your custom model and code that looks like:

String queryString = "select * from cmis:document content JOIN idoc:typeDocument tDoc ON content.cmis:objectId = tDoc.cmis:objectId WHERE content.cmis:objectId is not null AND tDoc.idoc:idTypedocument = '3'";
ItemIterable<QueryResult> results = session.query(queryString, false).getPage(5);

That returned my expected results, which is a document with its idoc:idTypedocument set to 3.

I also tried it using your <= AND >= workaround and it returned the exact same result.

Re: "=" and "IN" operators doesn't work in CMIS query

aminebarbare — Tue, 11 Oct 2016 13:25:57 GMT

Does 201605-GA refer to a new alfresco version (5.xx) ? because the version i'm currently using is Version :Community - v4.2.0 (r63893-b12).

Re: "=" and "IN" operators doesn't work in CMIS query

janv — Tue, 11 Oct 2016 16:46:01 GMT

Yes, Community 201605 GA includes Platform 5.1.g

Alfresco Community Edition 201605 GA Release Notes

https://svn.alfresco.com/repos/alfresco-open-mirror/alfresco/COMMUNITYTAGS/5.1.g/root/projects/repository/config/alfresc…

Regards,

Jan

Re: "=" and "IN" operators doesn't work in CMIS query

jpotts — Wed, 12 Oct 2016 22:27:48 GMT

I also tried this on 4.2.0 (r63893-b12) schema 6033 but for that test I used the out-of-the-box model and the following query, which should effectively be the same as yours with a custom model:

queryString = "select * from cmis:document content JOIN cm:titled tDoc ON content.cmisbjectId = tDoc.cmisbjectId WHERE content.cmisbjectId is not null AND tDoc.cm:title = 'sample-title'";

Can you set a title on one of your documents and try this query?

Re: "=" and "IN" operators doesn't work in CMIS query

aminebarbare — Thu, 13 Oct 2016 17:03:25 GMT

I'm sorry, I forgot to mention that the operators work just fine with the alfresco built in properties like the "title", that's why i asked if i am forgetting something in the aspect/property definition.