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.

Unable to query cmis:name?

ajperez

Hi, I'm retrieving data from Alfresco (3.3.0g community) from another application, using OpenCMIS SQL queries. Please take a look at these query results:

QUERY:  select cmis:name from cmis:document
RESULT: 1 document retrieved, cmis:name = something.pdf

QUERY:  select cmis:name from cmis:document where cmis:name = 'something.pdf'
RESULT: no documents retrieved
‍‍‍‍‍‍‍

In other words, I can query the "cmis:name" column, but I cannot filter it. Is that true, or am I missing something? Is there another way to use cmis:name inside the "where" part?

Find more posts tagged with

Comments

ajperez

Weird…

I had Alfresco 3.3.0 and updated it to 3.3.0g. I can't filter by cmis:name on nodes existing before the update, but it works for nodes created post-update. Maybe I just need to regenerate the Lucene indexes?