5 Advanced Backend Features

The DDS backend service supports many SQL query commands. Some of these commands can be added to a query using the components available in the DDS UI, while others must be added by manually typing them into the query itself. Once that is done, the query can then be run through the DDS UI, or a browser, or a cURL commands to get the results.

Follow the instructions in the "Query Builder" section within the "Designer Tab Guide" section of the "User Interface" chapter for instructions on setting up a basic query in the DDS UI. Once those steps have been followed, a query is generated in the GET box. The query can be edited to add the following statements individually or in a combination as required.

Note:

Please maintain the formatting of the GET request, making sure all the special characters (like the separating ampersand &) are in place, a lack of which may cause unexpected errors.

Note:

However, before any of the following commands can be run we need an access_token, which is mandatory when using applications using OAuth2.0 authentication. The process to create an OAuth2.0 application and getting the access token is discussed in the chapter Security Setup.