03-07-2019 12:14 PM
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
03-07-2019 01:10 PM
In URLs % characters have to be escaped. This is not specific to Nuxeo.