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".