Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-9879

Fix : Possibility to query on system properties with operator StartWith

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.5, 5.6-SNAPSHOT
    • Fix Version/s: 5.7.1
    • Component/s: Query & PageProvider

      Description

      If I use the startwith operator on a query with ecm:primaryType, the query crashes : 

      Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception: org.nuxeo.ecm.core.storage.sql.jdbc.QueryMaker$QueryMakerException. message: No such property: ecm:primaryType
	at org.nuxeo.ecm.core.storage.sql.jdbc.NXQLQueryMaker$WhereBuilder.getColumnInfo(NXQLQueryMaker.java:1268)
	at org.nuxeo.ecm.core.storage.sql.jdbc.NXQLQueryMaker$WhereBuilder.visitExpressionStartsWithNonPath(NXQLQueryMaker.java:1499)
	at org.nuxeo.ecm.core.storage.sql.jdbc.NXQLQueryMaker$WhereBuilder.visitExpressionStartsWith(NXQLQueryMaker.java:1472)
	at org.nuxeo.ecm.core.storage.sql.jdbc.NXQLQueryMaker$WhereBuilder.visitExpression(NXQLQueryMaker.java:1353)
	at org.nuxeo.ecm.core.query.sql.model.Expression.accept(Expression.java:42)
	at org.nuxeo.ecm.core.storage.sql.jdbc.NXQLQueryMaker$WhereBuilder.visitMultiExpression(NXQLQueryMaker.java:1338)
	at org.nuxeo.ecm.core.query.sql.model.MultiExpression.accept(MultiExpression.java:40)
	at org.nuxeo.ecm.core.storage.sql.jdbc.NXQLQueryMaker.buildQuery(NXQLQueryMaker.java:390)
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.query(JDBCMapper.java:669)
	at org.nuxeo.ecm.core.storage.sql.CachingMapper.query(CachingMapper.java:85)
	at org.nuxeo.ecm.core.storage.sql.SessionImpl.query(SessionImpl.java:1145)
	at org.nuxeo.ecm.core.storage.sql.ra.ConnectionImpl.query(ConnectionImpl.java:335)
	at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession$SQLSessionQuery.execute(SQLSession.java:589)
	at org.nuxeo.ecm.core.api.AbstractSession.query(AbstractSession.java:1518)

        Attachments

          Issue Links

          depends on

          Improvement - An improvement or enhancement to an existing feature or task. NXS-1185 Hide "startswith" operator on content views and searches for system properties

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          is required by

          Task - A task that needs to be done. NXS-1395 Allow "startswith" operator on content views and searches for system properties from 5.7

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: