Adding queries to a window

In addition to adding collection tabs to your window, you can also add custom queries or filters, which will also appear as tabs on your window. You can choose to display a single query on the tab, with the results of the query being shown on the tab. Alternatively, you can specify that many queries are displayed as a count list, much in the same way as in the Dashboard Designer.

To be able to add a query or filter to a window, you must have first designed it using the Query and Report Designer. For information about creating queries, see Query and Report Designer.

You cannot add prompted queries to a window, but can add filters that take values from the window. When adding filters to a window, you can add only filters that are based on the base class or super class of the window's object. For example, if you have a Workstation subclass on the Configuration Item object, then on the Workstation window you can add filters based on either Workstation or Configuration Item.

Query tabs are always displayed in Web Access, even if the query returns no results.

To add a single query to a window:
  1. Open the required window, and expand the Controls tree.
  2. Click Query, then click in the Window Editor.
    A new query collection appears at the bottom of the Window Editor.
  3. Ensure you have the query selected, then expand the Properties grid.
  4. Alongside the Display Index, specify the position in which the tab will appear.
    The positioning starts at 0. If you specified 1, then the query would appear on the second tab (that is, if you have more than one collection or tab on your window).
  5. Alongside the Query/Filter property select the relevant query or filter.
  6. Click .
Adding a number of queries as a count list to a window:
  1. Open the required window, and expand the Controls tree.
  2. Click Metrics, then click in the Window Editor.
    A new query collection appears at the bottom of the Window Editor.
  3. Ensure you have the query selected, then expand the Properties grid.
  4. Alongside the Display Index, specify the position in which the tab will appear.
    The positioning starts at 0. If you specified 1, then the query would appear on the second tab (that is, if you have more than one collection or tab on your window)
  5. Alongside the Queries property, click , and select the queries that you want to add to the tab, then click OK.
  6. Click .

Adding queries to a window that are not based upon the same business object