Adding a second parameter to a page provider

andrew_lam — Tue, 07 Jul 2020 22:01:12 GMT

Hello,

I am trying to modify the page provider used by the top search bar by adding a second parameter. I have followed the example in this post.

https://answers.nuxeo.com/general/q/cbd27e23ddc547058d3cc4bfb1f5658d/How-to-filter-in-the-Single-Multiple-Document-suggestion-widget-Documents-fetched

The use case from the post is pretty much exactly what I want and I've tried replicating it, but I run into this error.

2020-07-07T16:42:07,985 WARN  [http-nio-0.0.0.0-8080-exec-10] [org.nuxeo.ecm.platform.query.nxql.CoreQueryDocumentPageProvider] Failed to execute query: SELECT * FROM Document WHERE ecm:fulltext LIKE 'abs*%' AND ecm:isProxy = 0 AND ecm:mixinType = 'Folderish' AND ecm:mixinType != 'HiddenInNavigation' AND ecm:isVersion = 0 AND ecm:isTrashed = 0 AND ecm:path STARTSWITH ", Syntax error: Invalid token <null> at offset -1
org.nuxeo.ecm.core.query.QueryParseException: Failed to execute query: SELECT * FROM Document WHERE ecm:fulltext LIKE 'abs*%' AND ecm:isProxy = 0 AND ecm:mixinType = 'Folderish' AND ecm:mixinType != 'HiddenInNavigation' AND ecm:isVersion = 0 AND ecm:isTrashed = 0 AND ecm:path STARTSWITH ", Syntax error: Invalid token <null> at offset -1
	at org.nuxeo.ecm.core.query.sql.parser.parser.parseFailed(parser.java:519) ~[nuxeo-core-query-10.10-HF21.jar:?]
	at org.nuxeo.ecm.core.query.sql.parser.parser.unrecovered_syntax_error(parser.java:510) ~[nuxeo-core-query-10.10-HF21.jar:?]
	at java_cup.runtime.lr_parser.parse(lr_parser.java:601) ~[java-cup-0.11a.jar:?]

(I've also included the entire error message as a file.)

Here is the page provider.

<extension target="org.nuxeo.ecm.platform.query.api.PageProviderService" point="providers">

  <coreQueryPageProvider name="TEST_PP">
    <pattern quoteParameters="false" escapeParameters="true">
      SELECT * FROM Document WHERE ecm:fulltext LIKE '?%' AND ecm:isProxy = 0 AND
      ecm:mixinType = 'Folderish' AND ecm:mixinType != 'HiddenInNavigation'
      AND ecm:isVersion = 0 AND ecm:isTrashed = 0 AND ecm:path STARTSWITH '?' 
    </pattern>
    <parameter>#{documentManager.getParentDocument(currentDocument.parentRef).path}</parameter>
    <pageSize>50</pageSize>
  </coreQueryPageProvider>

</extension>

I have also tried just putting a plain string in the parameter node like this

<parameter>/base</parameter>

And I've also come across the same error.

Please let me know what I am doing incorrectly or if there is any more information needed to help solving this issue.

topic Adding a second parameter to a page provider in Nuxeo Forum

Adding a second parameter to a page provider