DataView Input Parameter Operators

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.

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.