Since a Query can have parameters, it can be made aware of bindings. Their values replace the specified From Parameters in the query. The Query Binding parameters must exactly match the Required Parameters.
For more information about using parameters, see Query Definition Settings and Deriving a Query from Another Query . For information about aggregations see Creating an Aggregation .
• |
The selection criteria, or the where clause. |
If parameters are passed to a query, you can use them to compare the properties of selected objects to refine the Where clause.
You cannot create a copy of a query and give it the same name as another query in your module. If you enter a name that is already in use, an alert icon () is displayed beside the field and the Save button is disabled.
1 |
Select Configuration > Definitions in the navigation panel. |
2 |
3 |
In the Module Contents pane, click the Queries tab. |
4 |
Click Add. |
5 |
Select the Copy an Existing Query tab. |
7 |
Click OK. |
A derived query may extend its base query’s list of Required Parameters, and replace its Filter Results Based on TopN, Aggregations, Order By and Where sections. If the derived query adds Required Parameters, their numerical order comes after that of the base query.
1 |
From the navigation panel under Dashboards, click Configuration > Definitions. |
2 |
3 |
In the Module Contents pane, click the Queries tab. |
4 |
Click Add. |
5 |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Nutzungsbedingungen Datenschutz Cookie Preference Center