WhereField Object

The WhereField Object is a WhereExpression subclass used to hold a reference to a table field. For example, in the expression customerid = 15, the left side would be a WhereField containing customerid as a field name.

Where expressions are used to filter a request by applying extra conditions. They are generally stored as XML formatted strings, however, the scripting implementation can unwrap these into a tree. The WhereBuilder object can be used to create new instances of these objects.

The code snippet below shows how the WhereField Object can be used:

var LowerValue = WhereBuilder.createConstant(lowerValue,'int');
var UpperValue = WhereBuilder.createConstant(upperValue,'int');
var BetweenCond = WhereBuilder.createBetween(WhereBuilder.createField('Orders','OrderID'),LowerValue,UpperValue);

Properties

table

Represents the name of the table to reference.

field

Represents the name of the field to reference.