-
Type: New Feature
-
Status: Resolved
-
Priority: Minor
-
Resolution: Fixed
-
Affects Version/s: 5.8.0-HF31, 6.0-HF07, 7.2-SNAPSHOT
-
Component/s: Query & PageProvider
In the platform's Web UI:
- I create a File manually with the title test"something
- After creation, I export the document as XML and see that the path contains the quote
This is troublesome for NXQL queries, for instance in Studio, using the SELECT * FROM Document WHERE ecm:path STARTSWITH '@{Document.path}' query in the Fetch > Query operation
=> if the path is not escaped, this can lead to errors
=> if the path is escaped, the query does not provide any result
With the new Fn.nxqlEscape, the solution, is to use SELECT * FROM Document WHERE ecm:path STARTSWITH '@{Fn.nxqlEscape(Document.path)}'
–
Fn.nxqlEscape can now be used in Automation MVEL expressions. Ex:
SELECT * FROM Document WHERE ecm:path STARTSWITH '@{Fn.nxqlEscape(Document.path)}'
- is required by
-
NXS-2886 Add the automation function nxqlEscape to automation suggestions
- Open