Specifying DataView Setup Information - Input Parameters Tab

  1. 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.
  2. Save your changes and continue.
Related topics