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

ANSWER