As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.
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.
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 = '?*' **
Note: PageProvider may give WARNING .. Please ignore and use, it works.
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.
STARTSWITH
ecm:path
/
My property value has not the form of a /-separated path.