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);
Represents the name of the table to reference.
Represents the name of the field to reference.