cancel
Showing results for 
Search instead for 
Did you mean: 

querying for images using cmisql / which columns are available

nuddlegg_
Champ in-the-making
Champ in-the-making

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 REPLIES 0
Getting started

Find what you came for

We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.