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:
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?
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