DataView Input Parameter Operators

This table presents a list of the valid operators for DataView input parameters:

Operator Description
Contains This operator automatically places wildcards at the beginning and end of the value entered by a user and then uses a LIKE operator for comparison.

For example, if a user were to enter cycle for a Property Name > Contains parameter, the system would filter using Name LIKE '%cycle%'. This would return all customers where the name includes "cycle", including "Coordinated Bicycles", "Bicycles R Us", "Cycle Works", and so on.

Date Range This operator is intended for use only with predefined date ranges. To provide the list of predefined dates, use the WBDateRange component class.
Note: To set up a date range to compare two user-entered dates, you must use two input parameters in tandem, using a Greater Than Or Equal To operator and a Less Than Or Equal To operator.
Equals This operator compares the value of the Property Name with the value input by the user. If the two are the same, the record is included in the results.
Filter Parameter This operator makes a value input by the user available to be used in the DataView's "filter". This operator is typically used in cases where the filter is too complex to use more simple operators, such as "Greater Than".
Greater Than This operator compares the value of the Property Name with the value input by the user. If the value input by the user is greater than the value of the Property Name, the record is included in the results.
Greater Than Or Equal To This operator compares the value of the Property Name with the value input by the user. If the value input by the user is greater than or equal to the value of the Property Name, the record is included in the results.
Less Than This operator compares the value of the Property Name with the value input by the user. If the value input by the user is less than the value of the Property Name, the record is included in the results.
Less Than Or Equal To This operator compares the value of the Property Name with the value input by the user. If the value input by the user is less than or equal to the value of the Property Name, the record is included in the results.
List This operator expects a space-padded list of input values.

For example, if the user entered BJS RMW in a Salesperson input field, the DataView would filter to show data both for "BJS" and for "RMW."

Not Equal This operator compares the value of the Property Name with the value input by the user. If the two are NOT the same, the record is included in the results.