topic Re: Lucene search vs CMIS query search in Alfresco Forum

Lucene search vs CMIS query search

kartech11 — Wed, 29 Aug 2018 17:19:33 GMT

1. I have documents that refer to property values from multiple custom aspects. I would like to know if I can do a CMIS type search on different properties using AND or OR criteria similar to in a lucene query.2. With lucene search, I only need to specify the various property and its values to sear

Re: Lucene search vs CMIS query search

afaust — Wed, 29 Aug 2018 19:29:11 GMT

NEVER do a Lucene search. Lucene is a legacy search language only included for low-level technical use cases. Only ever user FTS or CMIS QL.

In CMIS QL you can use AND / OR for conditions on different properties, but you cannot use OR to select different types / aspects as these are always selected via the FROM clause which only supports restricting, not broadening of scopes.

As for your example use case, since you are only using AND to join the conditions, it would work with CMIS. You'd select FROM cmis:document, then JOIN with each of the aspects to able to select those properties.

Re: Lucene search vs CMIS query search

jpotts — Wed, 29 Aug 2018 21:57:06 GMT

CMIS query join example: This is the query example from the OpenCMIS Workbench modified with a query string that shows how to query for propertie…

Re: Lucene search vs CMIS query search

kartech11 — Thu, 30 Aug 2018 13:21:30 GMT

Thanks Jeff Potts . The only downside I see to using CMIS query is that I have to know the specific aspect types for each of the properties that I am searching. I want to make a generic search query that can take property fields that could belong to different aspect types and search for values against them? Is this possible using CMIS query language? Can I use FTS query within CMIS and is there a way around the above issue?

Re: Lucene search vs CMIS query search

afaust — Thu, 30 Aug 2018 14:38:34 GMT

CMIS provides a dictionary that you can use to lookup the aspect for a specific property. So you can write generic code that builds the CMIS query with all the JOINs that you need and in your client code simply just specify the properties you want to query on. One of my customers has been working with CMIS in that way for years, based upon a small library they wrote for their use which did the query generation.

Re: Lucene search vs CMIS query search

kartech11 — Thu, 30 Aug 2018 15:53:22 GMT

Thanks Axel Faust‌ , I tried searching for CMIS dictionary but couldn't find any reference to how to access the dictionary. Can you please point me to any reference material or let me know to get access it, would be really helpful.

Re: Lucene search vs CMIS query search

afaust — Thu, 30 Aug 2018 16:47:24 GMT

Check the CMIS Repository services. You'll have to iterate through all types to find your properites, but this can be done once to build a local cache of the dictionary, and then you have a direct lookup of properties to their type (primary / secondary = aspect)