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

Fetch-Query in Studio and < > characters breaks the query

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.7.1
    • Fix Version/s: 5.7.3
    • Component/s: Automation
    • Tags:
    • Backlog priority:
      610

      Description

      in the Studio, say you have Fetch > Query operation in a chain. Such as:

      SELECT * FROM Document WHERE dc:created < DATE '2013-07-19'

      At runtime, it does not work. The server complains, because "<" became "<"
      ----------
      Caused by: org.nuxeo.ecm.core.query.QueryParseException: org.nuxeo.ecm.core.query.QueryParseException: Lexical Error: Illegal character <&> at offset 40 in query: SELECT * FROM Document WHERE dc:created < DATE '2013-07-19'
      ----------

      I was testing with some custom field:
      [...] AND activity:grade < 11

      So, basically, the query statement is broken. I don't know if the responsibility goes to the Studio or to the runtime. Or both. As I'm writing the statement in the Studio, I gave this bug to the Studio

      The workaround can be to use BETWEEN instead...
      [...] AND activity:grade BETWEEN O AND 10
      ... but it's not natural.

      That's why I set it to "critical" => I think it will break updates made by the customers (if they use such encoded characters)

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: