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!