querying for images using cmisql / which columns are available
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2013 09:34 AM
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
