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

STARTWITH clause is no longer supported on fields other than ecm:path

    XMLWordPrintable

    Details

      Description

      Typically "select * from Document where dc:coverage STARTSWITH 'europe'" does not work anymore
      =>
      org.nuxeo.ecm.core.storage.sql.QueryMaker$QueryMakerException: STARTSWITH requires ecm:pathas left argument

      Action : Change the QueryModel to automatically convert the query
      => "select * from Document where dc:coverage LIKE 'europe%'"

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: