How to execute SQL query in Search Resource Endpoints

Hi Eveybody Im triying execute the next endpoint http://localhost:8080/nuxeo/api/v1/search/lang/(psq,sql,potsgressql,etc)l/execute?query=SELECT * FROM documento_base But the execute return a Exception: … “infos”: [], “statusCode”: 400, “originalMessage”: “invalid query language”, “message”: “invalid query language”, “localizedMessage”: “invalid query language”, “suppressed”: []

It's posibble execute pure SQL wiht the endpoint?

Note: I use the endpoint with Page Provider (default nuxeo “nxql_search”) http://localhost:8080/nuxeo/api/v1/search/pp/nxql_search/execute?currentPageIndex=0&offset=0&pageSize=40&queryParams=SELECT * FROM Document WHERE ecm:mixinType != 'HiddenInNavigation' AND ecm:isProxy = 0 AND ecm:isVersion = 0 AND ecm:isTrashed = 0

But is not possible get only columns (attributes) example select dc:title from document the request is successfully but the content is null

Regards!

0 votes

1 answers

775 views

ANSWER



Hello,

Why do you need to retrieve only specific columns? Why not using NXQL? That's the way to go when quering for documents.

Regards

0 votes