https://connect.hyland.com/t5/nuxeo-forum/querying-for-images-using-cmisql-which-columns-are-available/m-p/325761#M12762 <P>I wonder why a cmisql query like</P> <PRE><CODE> select * from cmis:document where cmis:contentStreamMimeType='image/jpeg' </CODE></PRE> <P>fails with a Cannot use column in WHERE clause: cmis:contentStreamMimeType error?</P> <P>Or put the other way: why can't I query the contentStreamMimeType property?</P> <P>Which columns are available in cmisql?</P> <PRE><CODE>select * from cmis:document where cmis:objectTypeId='Picture' </CODE></PRE> <P>does fine, but that's not working out on alfresco.</P> <P>I'd prefer to use cmisql in a vendor-agnostic way...</P> Thu, 11 Jul 2013 13:34:32 GMT nuddlegg_ 2013-07-11T13:34:32Z https://connect.hyland.com/t5/nuxeo-forum/querying-for-images-using-cmisql-which-columns-are-available/m-p/325761#M12762 <P>I wonder why a cmisql query like</P> <PRE><CODE> select * from cmis:document where cmis:contentStreamMimeType='image/jpeg' </CODE></PRE> <P>fails with a Cannot use column in WHERE clause: cmis:contentStreamMimeType error?</P> <P>Or put the other way: why can't I query the contentStreamMimeType property?</P> <P>Which columns are available in cmisql?</P> <PRE><CODE>select * from cmis:document where cmis:objectTypeId='Picture' </CODE></PRE> <P>does fine, but that's not working out on alfresco.</P> <P>I'd prefer to use cmisql in a vendor-agnostic way...</P> Thu, 11 Jul 2013 13:34:32 GMT https://connect.hyland.com/t5/nuxeo-forum/querying-for-images-using-cmisql-which-columns-are-available/m-p/325761#M12762 nuddlegg_ 2013-07-11T13:34:32Z