topic Unable to query cmis:name? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/unable-to-query-cmis-name/m-p/222582#M175712 <HTML><HEAD></HEAD><BODY><SPAN>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:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />QUERY:&nbsp; select cmis:name from cmis:document<BR />RESULT: 1 document retrieved, cmis:name = something.pdf<BR /><BR />QUERY:&nbsp; select cmis:name from cmis:document where cmis:name = 'something.pdf'<BR />RESULT: no documents retrieved<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>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?</SPAN></BODY></HTML> Thu, 08 Jul 2010 12:57:30 GMT ajperez 2010-07-08T12:57:30Z Unable to query cmis:name? https://connect.hyland.com/t5/alfresco-archive/unable-to-query-cmis-name/m-p/222582#M175712 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:&nbsp; select cmis:name from cmis:documentRESULT: 1 document retrieved, cmis:name = something.pdfQUERY:&nbsp; select cmis:name from cmis:document where Thu, 08 Jul 2010 12:57:30 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-query-cmis-name/m-p/222582#M175712 ajperez 2010-07-08T12:57:30Z Re: Unable to query cmis:name? https://connect.hyland.com/t5/alfresco-archive/unable-to-query-cmis-name/m-p/222583#M175713 <HTML><HEAD></HEAD><BODY><SPAN>Weird…</SPAN><BR /><BR /><SPAN>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?</SPAN></BODY></HTML> Fri, 09 Jul 2010 10:44:08 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-query-cmis-name/m-p/222583#M175713 ajperez 2010-07-09T10:44:08Z