topic STARTSWITH on simple String property in pageprovider does not works in Nuxeo Forum

STARTSWITH on simple String property in pageprovider does not works

Yvan_Frezefond — Tue, 22 Oct 2019 09:42:09 GMT

Hello,

I have no result when I use STARTSWITH predicate in my page provider on a simple String property. If I change the predicate with a LIKE all is working.

Is there someone with the same issue ?

Thanks.

Re: STARTSWITH on simple String property in pageprovider does not works

__11 — Wed, 23 Oct 2019 04:36:17 GMT

Write the NXQL query without the "SELECT * FROM Document WHERE" part which is already generated).

Then add your where clause conditions which need to filter for specific DocType.

Also use this **AND ecm:fulltext = '?*' **

Re: STARTSWITH on simple String property in pageprovider does not works

__11 — Wed, 23 Oct 2019 04:39:10 GMT

Note: PageProvider may give WARNING .. Please ignore and use, it works.

Re: STARTSWITH on simple String property in pageprovider does not works

Yvan_Frezefond — Wed, 23 Oct 2019 07:06:34 GMT

The explication is in the documentation :

STARTSWITH matches path-like values. When used with ecm:path, it matches documents whose path is strictly under the specified path. When used with an arbitrary string-based property, it assumes that the property value has the form of a /-separated path, and then matches if the value is equal to or under the specified path.

My property value has not the form of a /-separated path.

Thanks.