ExtraView offers the user a number of different ways to query the database for results that match their search criteria. The query screen offers two primary methods in which to search the database, using the Standard Query Filters or the Advanced Query Filters. When you first enter the screen, you can click on the Query Options fold to see the full options.

Once you have created a set of filters, you can save these for future use, using the Save / Update Filters button.



The Standard Query Filter screen offers the ability to select from any of the filters displayed, and to use the combination of your selection as the filters to use to return results from the database. The results may be returned in the form of a Quicklist or a Detailed Report. The format of these reports are fixed by the Administrator, and may vary across your system, according to the Business Area within which you are working. The output of the Quicklist or Detailed Report that you produce can be set to your browser, to Text, to Microsoft Word, Microsoft Excel, or Adobe PDF using the Report Output Directives.


With the Advanced filter screen, you set up each filter individually, first selecting the field name, next the operator and then the value for filter. Note that operators are sensitive to the type of field. For example, with a list type field, you can select either equals or not equals as the operator, whereas with a numeric field, you can also select operators such as greater than or less than. It is also important to note that you can also select a conjunction between advanced filters. Typically this is used to select and or or, but can also be used for database operators such as union, intersect and minus.

QuickList Output

A Quicklist is a summary of the most important fields in your installation, similar to the example below:

To Run a Quicklist Report

Detailed Reports

The Detailed Report contains most, if not all of the information about each issue. The report might be similar to the following, but displaying fields pertinent to your site.

To Run a Detailed Report

Report Output Directives

Prior to producing a report, you may decide from among the following output options:

Note that charts may be output only to the browser.

To Choose an Output Format

Reference

Additional information: http://docs.extraview.com/extraview-23/end-user-guide/querying

 


Copyright © ExtraView Corporation, 1999-2023.  All rights reserved.