Add a Parameter to a Query Data Block

The Dashboard Builder recognizes parameters that are marked with a special tag of @{ }. To add a parameter to a Query Data Block:

1. Select the Query Data Block in which you wish to add a parameter, and mark the part of the SQL statement you wish to tag as a parameter with the @{} tag. (For example, the Query SQL statement TotalCPU>minCPU would be replaced TotalCPU>@{pminCPU} making pminCPU the parameter).
2. When you are done, click the Apply button. The parameter you tagged (in this example pminCPU) appears in the Input Bindings section as the Query Data block is now expecting an input for that parameter.
3. You can now connect an input source to the Query Data block as desired (for example an Option List block to make the selection from the Option List the input source for the query).

NOTE: When using Group in a parameter, you need to add a | as part of the statement for this parameter to work (for example GROUPNAME = @{pGROUPNAME|Group}).