Operator (Property)

Applies To:

Limit object

Description:

Returns or sets the value of a filter operator. The operator is applied to the filter criteria when executing a query or recalculating a Results set. If the operator is set to Equal, only the values which are exactly equal to the filter criteria, are returned or displayed.

Action:

Read write, BqLimitOperator

Constants:

The Operator (Property) uses the BqLimitOperator constant group, which consists of these values:

bqLimitOperatorBeginsWith
bqLimitOperatorBetween
bqLimitOperatorContains
bqLimitOperatorCustomSQL
bqLimitOperatoEndsWith
bqLimitOperatorEqual
bqLimitOperatorGreaterThan
bqLimitOperatorGreaterThanOrEqual
bqLimitOperatorIsNull
bqLimitOperatorLessThan
bqLimitOperatorLessThanOrEqual
bqLimitOperatorLike
bqLimitOperatorNotEqual

Example:

This example shows how to modify values of an existing results limit:

MyLimit = ActiveDocument.Sections["Results"].Limits[1]
//Clear all the values which are currently set
MyLimit.SelectedValues.RemoveAll()
// add new values to the selectedvalues collection
MyLimit.SelectedValues.Add(2000)
//Change the limit criteria
MyLimit.Operator = bqLimitOperatorLessThan