nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

CMIS query with IN_TREE and other attribute not working

sistemi

Hi everybody, I have upgraded my Alfresco community from 5.2 - 201707 to version 6.1.2 - 201901 .

Everything works normally except CMIS queries that include IN_TREE AND another attribute. Queries that uses separately IN_TREE or other attributes work and give the expected results:

SELECT * FROM contoso:invoiceA where IN_TREE('5bb2532a-b989-4571-893d-87f0d78fd359') - works

SELECT * FROM contoso:invoiceA where contoso:code = 'SP' - works

SELECT * FROM contoso:invoiceA where IN_TREE('5bb2532a-b989-4571-893d-87f0d78fd359') and contoso:code = 'SP' - does not work

Do you have any clue? Those queries all gave expected results when used with Alfresco 5.2 - 201707.

Find more posts tagged with

Alfresco Content Services

Comments

angelborroy

I guess there is some problem with your SOLR index, as this query should work.

Try re-indexing your repository.

gstv

Hi,

I don't know if you've finally figured this out, I had a similar issue recently.

In my case, it had to do with the metadata "sys:locale", which apparently is taken from the application server. In the Tomcat where the Alfresco 5.2 was deployed the value was set to "es_ES.UTF-8", whereas in the new Tomcat for the Alfresco 6.1 it was set to "en_US.UTF-8". After changing the value to "es_ES.UTF-8" and re-indexing the search is working as expected.