Specifying DataView Setup Information - Input Parameters Tab
-
When you set up a predefined DataView, specify this information on
the
Input Parameters tab of the
DataViews Setup form:
Note: The options on this tab can be especially helpful when setting up a DataView to be used to create reports.
- Sequence
- Use integers to indicate the order in which the specified input parameters is applied to the data being queried.
- Operator
- When used, this value specifies an operation to use in
setting a range for the data to be retrieved. When two such operators are used
in tandem, you can set an upper range limit and a lower range limit.
For example, suppose you want to retrieve the values of all customers whose names begin with the letter 'C'. You could create one parameter using the operator Greater Than Or Equal To with a Description value of C. You could then create a second parameter using the operator Less Than, with a Description value of D. By applying both of these parameters to the Property Name of CustName, you effectively set a range for customers whose names begin with the letter 'C'.
Note: If the Source Type on the General tab is set to IDO Method, this field is disabled. - Property Name
- Use the drop-down list to specify the IDO property to be used
as the input parameter.
When you select a property in this field, the Description field is automatically populated with the default value for the property, if one exists. You can modify the value in the Description field, if desired.Note: If the Source Type on the General tab is set to IDO Method, this field is disabled.
- Description
- Specify the value to be used as the input parameter. If a Property Name is specified, this value is specified automatically but can be changed. This is the value on which the Operator, if any, performs.
- End of Day
- This option is enabled only when the specified property is a
date/time property. When selected, this option causes the time on a Date/Time
property value to be set to the "end of day," which is defined in the system as
11:59:59.99 PM. When cleared, the system
uses the system date/time that the user performed the query. The use of this
option allows you to set very precise date/time ranges.
Note: If the Source Type on the General tab is set to IDO Method, this field is disabled.
- Save your changes and continue.