Updating a query or qualification at runtime
When you open the Report Console to run a report, AR System uses the report's built-in query to select the records included in the report. Use the following options to add a qualification:
- Show Additional Filter to narrow the report results
- Override to override the built-in query to widen or change the report results
If the Edit icon (
) appears next to a report entry in the Report Console, you can open the report definition to examine the built-in query.
Adding or modifying a qualification at runtime
A qualification is a query statement, such as Number enrolled is greater than 0. If you enter an additional qualification using Show Additional Filter, and do not select Override, your qualification is added to the report's built-in query by using the AND operator. If you enter an additional qualification and select Override, then your qualification replaces the report's built-in query. If you select Override but do not enter a qualification, then the report's built-in query is ignored.
To add or modify a qualification at runtime by using Show Additional Filter and Override
- Open the Report Console and from the list of reports, select the report to run.
- Click Show Additional Filter.
- By using the Simple Query Builder or the Advanced Query Builder, build the additional qualification as described in Restricting-access-to-web-report-records-by-using-a-query-builder.
(Optional) Select Override to replace the report's built-in query with the added qualification.
- Click Run to run the report with the added qualification.
Restrictions on modifying qualifications at runtime
Some reports do not allow modification at runtime. The Show Additional Filter and Override options are unavailable in the following cases:
- If you search a form and use the Report button in the search results list to create a report, the records that you selected in the search results are passed to the Report Console as a predefined query. In this case, the Show Additional Filter and Override options are not available.
Override does not override the base qualification used in AR System reports. A base qualification is defined by the administrator and is outside of the report definition. If the report contains a base qualification, the qualification that you define is added to the base qualification. Base qualifications are not visible on the report designer screen.
Out-of- the-box Web reports provided with BMC Helix ITSM cannot be modified even if the user is an application administrator because the reports are not created by using the AR System Report Console. However, an application administrator can delete the reports.
- The administrator can make unqualified searches unavailable for reports. In other words, 1=1 qualifications are not allowed for reports. In this case, attempts to run a report for an unqualified search result in an error.
Example: Overriding a report query
A training program manager needs to see a list of all classes, including those where the enrollment is zero. Instead of writing a new report, the manager could use the Class Registration report, but override the built-in query. By overriding the built-in query and adding no additional conditions, the manager eliminates the built-in query. This widens the report results to include those classes that have no enrollees.
The manager could also use the Override and Show Additional Filter options together to replace any built-in query in the report. For example, to see a list of all classes in Madrid with or without students enrolled, the manager could use the Class Registration report, add the query "Location is LIKE Madrid%", and click Override. The additional query narrows the report to include only classes in Madrid, and the override causes the report to include classes with no enrollees and classes with students enrolled.
Where to go from here
Creating-and-managing-reports-from-the-AR-System-Report-Console