topic Re: CMIS CONTAINS() not finding documents as expected in Alfresco Archive

CMIS CONTAINS() not finding documents as expected

rmcveigh — Mon, 14 Mar 2011 15:23:23 GMT

I'm using 3.4 Enterprise. Using the Share UI, I can search for the string "test" and find content nodes as expected. I can use the advanced search scoped to a custom content type and still find instances of that type. However, executing a CMIS search isn't finding the documents. I've triedselect

Re: CMIS CONTAINS() not finding documents as expected

rmcveigh — Mon, 14 Mar 2011 15:33:08 GMT

I should clarify my goal: I wish to search for a given string across all indexed properties of a custom content type. So while this works: select * from my:type where contains('cmis:name:test')

This isn't realistic unless I want to OR all my custom properties in - which I assumed wasn't necessary.

-Ryan

Re: CMIS CONTAINS() not finding documents as expected

andy — Wed, 16 Mar 2011 14:57:50 GMT

Hi

CONTAINS() uses TEXT as the default field (it may well not be exposed to use direct).
TEXT is any property of type d:content.

The share UI expands the query using something like the macro below:

"%(cm:name cm:title cm:description ia:whatEvent ia:descriptionEvent lnk:title lnk:description TEXT)

ALL can be used from share to search over all properties.
I would have to check if this is exposed in CMIS.

CONTAINS('ALL:test')

It is possible that ALL like TEXT is not exposed in your Alfrecso version…..
so what version are you using and can you post the rest of the stack trace.

Andy

Re: CMIS CONTAINS() not finding documents as expected

rmcveigh — Wed, 16 Mar 2011 15:45:16 GMT

Hi Andy, thanks for the reply. I'm running 3.4 Enterprise. I tried this query:

SELECT * FROM cmis:document WHERE CONTAINS('ALL:test')‍

When I do, I get a failure and this is in the log:

Caused by: org.alfresco.cmis.CMISQueryException: 02160067 Unknown column/property ALL
        at org.alfresco.cmis.search.CmisFunctionEvaluationContext.checkFieldApplies(CmisFunctionEvaluationContext.java:366)
        at org.alfresco.repo.search.impl.parsers.FTSQueryParser.buildFieldReference(FTSQueryParser.java:981)
        at org.alfresco.repo.search.impl.parsers.FTSQueryParser.buildFTSTest(FTSQueryParser.java:248)
        at org.alfresco.repo.search.impl.parsers.FTSQueryParser.buildFTSConnective(FTSQueryParser.java:169)
        at org.alfresco.repo.search.impl.parsers.FTSQueryParser.buildFTSConnective(FTSQueryParser.java:156)
        at org.alfresco.repo.search.impl.parsers.FTSQueryParser.buildFTS(FTSQueryParser.java:110)
        at org.alfresco.cmis.search.CMISQueryParser.buildPredicate(CMISQueryParser.java:457)
        at org.alfresco.cmis.search.CMISQueryParser.buildTest(CMISQueryParser.java:283)
        at org.alfresco.cmis.search.CMISQueryParser.buildNegation(CMISQueryParser.java:263)
        at org.alfresco.cmis.search.CMISQueryParser.buildConjunction(CMISQueryParser.java:232)
        at org.alfresco.cmis.search.CMISQueryParser.buildDisjunction(CMISQueryParser.java:205)
        at org.alfresco.cmis.search.CMISQueryParser.parse(CMISQueryParser.java:160)
        at org.alfresco.cmis.search.CMISQueryServiceImpl.query(CMISQueryServiceImpl.java:126)
        at org.alfresco.repo.cmis.rest.CMISScript.query(CMISScript.java:652)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: CMIS CONTAINS() not finding documents as expected

rmcveigh — Wed, 16 Mar 2011 17:35:13 GMT

Andy,

I've experimented some more and I'm able to do some interesting things to perhaps meet my requirement, but I'd like to believe there's a better way. My requirement is to execute a "full text" search across all indexed fields for a given content type (e.g. cmis:name, myType:field1, myType:field2, cm:content, cm:title, etc).

I can execute a query like:

select d.*, o.* from cmis:document as d join cm:titled as o on d.cmis:objectid = o.cmis:objectid where CONTAINS(d,'cmis:name:test OR cmis:createdBy:admin') OR CONTAINS(o,'cm:title:test')‍

This implies I can query on all indexed fields of my type by explicitly OR'ing them in the various scoped CONTAINS predicates. This seems heavy handed. Is there a better way?

Another approach which also works is:

select d.*, o.* from cmis:document as d join cm:titled as o on d.cmis:objectid = o.cmis:objectid where o.cm:title like '%25test%25' OR CONTAINS(d,'cmis:name:test')
‍‍

When would I prefer to use the LIKE predicate over CONTAINS or vice versa?

-Ryan

Re: CMIS CONTAINS() not finding documents as expected

andy — Tue, 22 Mar 2011 19:47:58 GMT

Hi

Sticking to the spec you are allowed one CONTAINS().

For now I would drop the alias in the CONTAINS and "OR" all the terms together in one single contains statement (with no alias)

It I remember correctly, the extended Alfrecso FTS embedded in CMIS should understand embedded "d.cm:content:woof" style. However, as we do not do any actual join and the CMIS contains does not actually check the property binding tot he type (as the default for CONTAINS() is non strict mode).

I will fix up the special pseudo fields like ALL, d:content to work in CMIS contains.

Andy

Re: CMIS CONTAINS() not finding documents as expected

rmcveigh — Wed, 23 Mar 2011 17:40:24 GMT

Thanks Andy,

I had been unable to use a single CONTAINS statement with both cmis properties and cm:title etc, I had to OR as I described above. Is there a JIRA issue I can track for the updates you've described?

-Ryan

Re: CMIS CONTAINS() not finding documents as expected

andy — Tue, 29 Mar 2011 13:13:41 GMT

Hi

The issue is here https://issues.alfresco.com/jira/browse/ALF-7827

Andy

Re: CMIS CONTAINS() not finding documents as expected

thestorm — Tue, 26 Apr 2011 13:52:31 GMT

whats the variable for fulltext content then? (I wanna query for fulltext index)

Re: CMIS CONTAINS() not finding documents as expected

andy — Tue, 10 May 2011 09:38:00 GMT

Hi

The additional fields are exposed in 3.4.3 and the related bug has been resolved.

Until you have this fix: CMIS contains searches all properties of type d:content (if you specify no field) or the specified properties you give.

CONTAINS('woof OR cmis:name:woof')

should search all content and the name property. TEXT:woof will be the same as woof on its own when the additional fields are available.

Andy

Re: CMIS CONTAINS() not finding documents as expected

andy — Wed, 21 Sep 2011 19:06:41 GMT

Hi

Please include the query, any realted data model fragments (property and type definitions) and the error.

Andy