Query parameters allow users to create variables to be used in an individual query and can be referenced multiple times within the query.
This feature facilitates writing queries that often refer to changing values the user would otherwise have to update hardcoded SQL for.
Example:
Write a query that looks up processes for a specific day that matches a name.
Note : The key is case sensitive. camelCase is recommended, but not required. Lowercase and underscores may also be used.
Note : Though closing the parameters dialog box results in displaying of parameters, since parameters pertain to an individual query, the query has to be saved for these parameters to be retained for later runs of the query.
SELECT * FROM processes WHERE name LIKE :name AND upt_day = :uptDay LIMIT 100
Known Issue(s) :
In the current release, once a query is saved with parameters, it is not possible to add / modify existing parameters. This is being addressed in future releases. Alternatively, a new query with intended set of parameters can be created.