cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to query cmis:name?

ajperez
Champ in-the-making
Champ in-the-making
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?
1 REPLY 1

ajperez
Champ in-the-making
Champ in-the-making
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?