querying for images using cmisql / which columns are available
I wonder why a cmisql query like
select * from cmis:document where cmis:contentStreamMimeType='image/jpeg'
fails with a Cannot use column in WHERE clause: cmis:contentStreamMimeType error?
Or put the other way: why can't I query the contentStreamMimeType property?
Which columns are available in cmisql?
select * from cmis:document where cmis:objectTypeId='Picture'
does fine, but that's not working out on alfresco.
I'd prefer to use cmisql in a vendor-agnostic way…
0 votes
0 answers
1623 views