Driect Database Request and Use of Presentation Variables

Let’s create a direct database request and see the use of presentation variables.

After clicking Create Direct Request, following layout will appear. Put your connection pool and SQL statement and then click Validate SQL and Retrieve Columns. If no error appears then everything is fine. Click Results and proceed.

Now as mentioned above, presentation variables can be used in Direct Database Requests.

Syntax:
@{variable_name}{default_value}

See the example SQL below:

You can put the request on Dashboard and utilize these presentation variables in dashboard prompt.

Cheers ;)