cancel
Showing results for 
Search instead for 
Did you mean: 

REST API deos not return results that NQXL search deos

YOUNES_Ouchtoub
Champ in-the-making
Champ in-the-making

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

1 REPLY 1

Florent_Guillau
World-Class Innovator
World-Class Innovator

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