-
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
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)
- duplicates
-
NXS-128 problem in query operation with '<' and '>'
- Resolved