Query management

Note: This feature is not yet available and this is the documentation for the old one.

The query management service allows you to create queries and configure parameters for reports that a user can run without technical knowledge.

When you select 'Query Management' from the menu, a list of the configured queries is displayed.

When you click the Edit button, you are presented with the query edit form.

You can enter the name, description, and SQL select for the query.  When the Header column is specified, the column will be used as a grouping column in the report.  If the sum column is specified for a numeric column, the numbers will be summarized and displayed with the group.

Where clause parameters can be added to the report. To use the parameter within the report SQL, add the parameter to your query using {1}, {2}, {3}, and so on where you want the parameter to be injected into the query.

Note: Future versions of PermeAgility will allow the assigning of roles to queries to limit the users that can run queries.  

Note: Users must have privilege to select from the tables used in the query to execute the query.