Queries may be formed and executed on any issue data stored within ExtraView.
Queries are composed using either standard or advanced filters. The results are presented using either a Quicklist or a Detailed Report. The results may be output to the user’s browser, to Microsoft Word, Microsoft Excel, Adobe PDF or to text.
The standard filters require the composition of a layout of the type SEARCH_QUICK. This should contain the most frequently used fields for queries. Users can select any number of filters on this layout to compose a query. When multiple filters are selected, the query engine places an “AND” conjunction between the filters. The user can select expanded query filters, in which case, multiple values can be selected within each field. This is an “OR” operation with the values of the filter field.
Advanced filters require the selection of the filters to be used in the query, one-by-one. However, the user can select from the entire range of fields to which they have read permission. The user may also set a conjunction between each filter, using “AND”, “OR”, “UNION”, “INTERSECT” or “MINUS”. Advanced filters take more time to set up, but offer significantly more capability. This includes the introduction of parentheses into compound queries.
Once prepared, filters sets may be stored and recalled.
Within the administration section of ExtraView the most important aspect that affects querying is to correctly set the following Data Dictionary fields, as explained in the Data Dictionary section of this guide:
- Allow selection on reports
- Total field on reports
- Filter criteria
- Is sortable