TableRequest Object

The TableRequest Object is used for server callbacks. On the server, this object is passed as a parameter to the beforeGetTable and afterGetData events in the Business Rules Scripting Events. The object contains information about the client's request.

Properties

userFilter

Gets/sets the filter passed to the server. This will contain raw SQL and is blocked by default.

includeSchema

Gets/sets the include schema flag. When set, the response will contain the full schema for the requested data.

maxRecords

Represents the maximum number of records to return, or <= 0 if unlimited.

parameterCount

Contains the number of parameters in this request.

where

Returns the Where data as a string (will contain XML when set).

whereBuilder

Returns the where data as a WhereExpression Object.

dynSelectFieldCount

Returns the number of dynamic select fields in the request.

sql

When using DA SQL requests, this contains the full SQL, this field defines if DA SQL requests are used or not.

Functions

dynSelectField(index)

Returns the name of the dynamic select field.

parameterName(index)

Returns the name of the parameter in the request (by index)

parameterValue(index)

Returns the value of the parameter in the request (by index).