NumericFilter Command |
|
Use the NumericFilter command in a Logic Template to filter out records that meet a specific criteria.
When dealing with large amounts of data it is often more efficient to use a range index to narrow the search. The NumericFilter command can then be used to fine tune the result set.
To execute a Numeric Filter request, use the NumericFilter command with three or four arguments:
NumericFilter( op, dat, val ); or NumericFilter( bd, dat, val, flag );
NumericFilter Arguments
Argument |
Description |
op |
The operator. |
dat |
The name of the data field to be tested. |
val |
The name of the HTML variable containing the value to test against. |
flag |
Indicate ( drop or keep ) special processing for records with a value of zero for dat. |
Access the NumericFilter Dialog Box by selecting Numeric->Comparison menu item under the Filtering category of the Logic Template editor command menu.
Examples
Command |
Description |
NumericFilter( NE, DataValue, FieldValue); |
Pass records containing, in the field named "DataValue", a value that is other than the value stored in HTML variable "FieldValue". |
NumericFilter( NE, DataValue, FieldValue, drop); |
Pass records containing, in the field named "DataValue", a value that is other than 0 and other than the value stored in HTML variable "FieldValue". |
NumericFilter( EQ, DataValue, FieldValue ); |
Pass records containing, in the field named "DataValue", a value that is equal to the value stored in HTML variable "FieldValue". |
NumericFilter( EQ, DataValue, FieldValue, keep); |
Pass records containing, in the field named "DataValue", 0 or a value that is equal to the value stored in HTML variable "FieldValue". |
NumericFilter( LTE, DataValue, FieldValue ); |
Pass records containing, in the field named "DataValue", a value that is less than or equal to the value stored in HTML variable "FieldValue". |
NumericFilter( LTE, DataValue, FieldValue, drop); |
Pass records containing, in the field named "DataValue", a value other than 0 that is less than or equal to the value stored in HTML variable "FieldValue". |