Creating Customized Views
Some MAINVIEW views do not display the desired data unless they are presented
with parameters. Some have way too much data and need to be filtered to extract
the particular desired set of data. You can create a customized view by taking
an existing view and customizing it.
- Directory This is the add-on directory defined in general setup
that will contain the view definition file.
- File name This is the file name that will be used to store the customized
view. The file type will be ".vdf". This is also the name that will
appear in the list of views.
- View description A description of the contents of this view. This text will
show up as a tool tip when the mouse pauses over the view name.
- Field to sort on To sort the results on one of the fields, enter the
name of the field here. The button on the right is used to select ascending versus
descending sort. A descending sort is useful in recording a "'Top Ten" list.
- View Parameters Parameters, separated by blanks, to be passed to the
view.
- QWHERE clause The filter clause to be applied as part of the query.
- WHERE clause The filter clause to be applied to the data resulting
from the query before sending it to the data server.
WHERE and QWHERE Syntax
These clauses have a basic syntax of fieldname op value, where fieldname is as
listed under the view, and op can be = <> > <. Multiple comparaisons can be
joined together with AND and OR. The clause is limited to 1000 chatacters.