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

Attention: Blogs & Forums are in READ-ONLY mode from Oct 9-19 as we transition to our new platform. Learn more.

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.