Combining report queries
Reports can include query definitions of the following types:
- Query contained in the report definition — This is any query in the report definition, for example, when you create an ad hoc report in the Report Console.
- Base qualification — The administrator can enter a base qualification using standard BMC Remedy AR System syntax in the Base Qualification field of the Report form. This allows the administrator to add a query to an existing report, without modifying the report definition itself.
In a base qualification, you must use the database field name and not the field label on the form.
- Runtime qualification — The user running the report can add additional qualifications to the query at runtime.
- Active link query — An active link that runs a report can include a qualification.
In any case where the Override option is not selected and the report includes more than one of these qualifications at runtime, the different queries are joined with an AND operator. Base qualifications are never overridden and are always joined to other qualifications with an AND operator.
Therefore, the effect of combining qualifications is to narrow the report to include only those entries that match all conditions of the combined queries.