-
Type: Bug
-
Status: Resolved
-
Priority: Minor
-
Resolution: Fixed
-
Affects Version/s: 6.0-HF22, 7.4
-
Component/s: Layouts & Widgets
-
Tags:
Regression introduced by NXP-17817.
Define a Document suggestion widget with a Nxql query like
SELECT * FROM Document WHERE dc:title ILIKE '%?%'
It causes the following error:
****** chain ****** Name: WebUI.RunOperationInSeam Aliases: [Seam.RunOperation] Exception: TraceException Caught error: ****** chain ****** Name: operation Exception: OperationException Caught error: Failed to execute query: SELECT * FROM Document WHERE dc:title ILIKE '%'lan'%', Syntax error: Invalid token <lan> at offset 47 Caused by: null ****** Hierarchy calls ****** org.nuxeo.ecm.automation.core.operations.services.DocumentPageProviderOperation Caused by: org.nuxeo.ecm.automation.OperationException: Failed to execute query: SELECT * FROM Document WHERE dc:title ILIKE '%'lan'%', Syntax error: Invalid token <lan> at offset 47 ****** Hierarchy calls ****** org.nuxeo.ecm.automation.seam.operations.RunOperationInSeam at org.nuxeo.ecm.automation.core.impl.OperationServiceImpl.run(OperationServiceImpl.java:232) at org.nuxeo.ecm.automation.core.impl.OperationServiceImpl.run(OperationServiceImpl.java:115) at org.nuxeo.ecm.automation.server.jaxrs.OperationResource.execute(OperationResource.java:51) at org.nuxeo.ecm.automation.server.jaxrs.ExecutableResource.doPost(ExecutableResource.java:61) ... 86 more Caused by: org.nuxeo.ecm.automation.TraceException: ****** chain ****** Name: operation Exception: OperationException Caught error: Failed to execute query: SELECT * FROM Document WHERE dc:title ILIKE '%'lan'%', Syntax error: Invalid token <lan> at offset 47 Caused by: null ****** Hierarchy calls ****** org.nuxeo.ecm.automation.core.operations.services.DocumentPageProviderOperation at org.nuxeo.ecm.automation.core.impl.OperationServiceImpl.run(OperationServiceImpl.java:232) at org.nuxeo.ecm.automation.core.impl.OperationServiceImpl.run(OperationServiceImpl.java:104) at org.nuxeo.ecm.automation.seam.operations.RunOperationInSeam.runChain(RunOperationInSeam.java:86) at org.nuxeo.ecm.automation.seam.operations.RunOperationInSeam.run(RunOperationInSeam.java:70) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at org.nuxeo.ecm.automation.core.impl.InvokableMethod.doInvoke(InvokableMethod.java:157) at org.nuxeo.ecm.automation.core.impl.InvokableMethod.invoke(InvokableMethod.java:170) at org.nuxeo.ecm.automation.core.impl.CompiledChainImpl.doInvoke(CompiledChainImpl.java:128) at org.nuxeo.ecm.automation.core.impl.CompiledChainImpl.invoke(CompiledChainImpl.java:114) at org.nuxeo.ecm.automation.core.impl.OperationServiceImpl.run(OperationServiceImpl.java:208) ... 89 more Caused by: org.nuxeo.ecm.automation.OperationException: Failed to execute query: SELECT * FROM Document WHERE dc:title ILIKE '%'lan'%', Syntax error: Invalid token <lan> at offset 47 at org.nuxeo.ecm.automation.core.operations.services.DocumentPageProviderOperation.run(DocumentPageProviderOperation.java:255) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at org.nuxeo.ecm.automation.core.impl.InvokableMethod.doInvoke(InvokableMethod.java:157) at org.nuxeo.ecm.automation.core.impl.InvokableMethod.invoke(InvokableMethod.java:170) at org.nuxeo.ecm.automation.core.impl.CompiledChainImpl.doInvoke(CompiledChainImpl.java:128) at org.nuxeo.ecm.automation.core.impl.CompiledChainImpl.invoke(CompiledChainImpl.java:114) at org.nuxeo.ecm.automation.core.impl.OperationServiceImpl.run(OperationServiceImpl.java:208) ... 101 more
- depends on
-
NXP-17817 Move '%' appended in nuxeo-select2.js to the page provider definition
- Resolved