Using the Ad hoc Query Builder

You can use the ad hoc query builder to build a query directly from the chart, or to further filter the data in the selected query. To access the ad hoc query builder, click the Filter icon at the top of the menu.

The options for an ad hoc query appear in the query builder panel, and are based on the application or business view associated with the JET application (chart). The ad hoc query builder enables you to select additional fields from the form and grid of the application and add conditions to narrow the data in the chart. When the chart is based on a business view, the query builder panel lists all of the columns available in that business view. You can select and add the required columns to the ad hoc query.

Ad hoc queries enable you to add filters that are more specific than the queries from the application or business view. The system combines the conditions defined in the application query and the ad hoc query to retrieve data.