REST API deos not return results that NQXL search deos

YOUNES_Ouchtoub — Thu, 07 Mar 2019 17:14:58 GMT

hi i'm facing an issue with the REST API, it works randomly, sometimes it returns the results im excpecting, but other time i got no result for query that are working in NXQL search for example here is a url i'm testing: https://mynuxeo/nuxeo/api/v1/query?query=SELECT * FROM Document WHERE fichier:vvvvvv LIKE '%XXXXX%' AND ecm:aaaa = 0 AND ecm:bbbb = 'yyyy' AND ecm:ccc = 0 this is not returning anything

but in the oder hand when i'm using NXQL search the same query (SELECT * FROM Document WHERE fichier:vvvvvv LIKE '%XXXXX%' AND ecm:aaaa = 0 AND ecm:bbbb = 'yyyy' AND ecm:ccc = 0) is returning results

any ideas?

Thank you

Re: REST API deos not return results that NQXL search deos

Florent_Guillau — Thu, 07 Mar 2019 18:10:34 GMT

In URLs % characters have to be escaped. This is not specific to Nuxeo.

topic REST API deos not return results that NQXL search deos in Nuxeo Forum

REST API deos not return results that NQXL search deos

Re: REST API deos not return results that NQXL search deos