Uploaded image for project: 'Alfresco One Platform'
  1. Alfresco One Platform
  2. ACE-2685

Error when using content length and mimetype in the same query

    Details

      Description

      select * from cmis:document
      where cmis:name like '%a%'
      and cmis:createdBy in ('System', 'admin')
      and cmis:creationDate < TIMESTAMP '2014-01-01T00:00:00.000Z'
      and cmis:lastModifiedBy not in ('me')
      and cmis:lastModificationDate > TIMESTAMP '2010-01-01T00:00:00.000Z'
      and cmis:contentStreamLength > 2
      and cmis:contentStreamMimeType IN ('text/plain')
      and cmis:contentStreamFileName LIKE '_%'
      order by
      cmis:contentStreamMimeType ASC, cmis:contentStreamLength DESC, cmis:creationDate ASC, cmis:name DESC

      Throws

          1. Error querying database. Cause: java.sql.SQLSyntaxErrorException: ORA-00904: "PROP_1"."MIMETYPE_STR": invalid identifier ### The error may involve alfresco.metadata.query.select_byDynamicQuery-Inline ### The error occurred while setting parameters ### Cause: java.sql.SQLSyntaxErrorException: ORA-00904: "PROP_1"."MIMETYPE_STR": invalid identifier ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00904: "PROP_1"."MIMETYPE_STR": invalid identifier

        Attachments

          Structure

            Activity

              People

              • Assignee:
                closedissues Closed Issues
                Reporter:
                ahind Andrew Hind [X] (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Structure Helper Panel