topic Re: CMIS query using IN_TREE and multi-value property in Alfresco Forum

CMIS query using IN_TREE and multi-value property

andrewlove — Thu, 04 Apr 2019 12:24:20 GMT

I am trying to query an Alfresco 5.2 repo using cmis-strict in the node browser.I have 5 documents in a folder tree.2 of those 5 documents have a multi-value property accountreference = 1927615 and a single value property crmindex = X1943G;.ULExample 1SELECT * FROM figaro:basetype WHERE IN_TREE('06

Re: CMIS query using IN_TREE and multi-value property

angelborroy — Fri, 05 Apr 2019 08:23:22 GMT

I've tried a similar approach with Alfresco 6.1 and Search Services 1.3.0.1 and it works for me.

SELECT * 
FROM figaro:basetype 
WHERE IN_TREE('e416ed7a-bb59-4805-ac86-aa6cbdcc4c9e') AND 
      '1927615' = ANY figaro:accountreference‍‍‍‍‍‍‍

Upgrading is an option?

Re: CMIS query using IN_TREE and multi-value property

andrewlove — Fri, 05 Apr 2019 08:31:37 GMT

Thanks for your input.

I’ve just rebuilt the entire Solr index and cleared out the Solr models.

The query now works as expected.

I’m not sure what went wrong there. It’s a bit worrying.

Re: CMIS query using IN_TREE and multi-value property

angelborroy — Fri, 05 Apr 2019 08:36:03 GMT

Re-indexing is required when introducing changes in the model. If your model is stable, no re-indexing should be required.

Re: CMIS query using IN_TREE and multi-value property

andrewlove — Fri, 05 Apr 2019 09:50:16 GMT

That might explain it. I added a new doc type using the model manager.

It it seems unfortunate that you can change the model interactively in model manager but still need to clear down Solr manually under the covers and rebuild the index.

Is there a simple way of doing this?

Re: CMIS query using IN_TREE and multi-value property

angelborroy — Fri, 05 Apr 2019 10:15:14 GMT

You can change the model, and the changes are updated in SOLR.

However if you are working with a new Model and make some tests, this documents will be indexed with existing properties.

When you modify the model and (for instance) you add a new property, new documents will be indexed with this new property, but old documents are not being indexed with the new one. You can re-index them manually or perform a full re-indexation.

In PROD environments, playing live with the Model is not the recommended approach.

Re: CMIS query using IN_TREE and multi-value property

andrewlove — Fri, 05 Apr 2019 10:26:25 GMT

Many thanks for the clarification