Viewfilterrule

A view filter rule [Viewfilterrule] is one of the criteria used in a view filter.

XML

SOAP

REST

Database table

Object

Viewfilterrule

oaViewfilterrule

viewfilter_rule

Supported Commands

Read

read()

The Viewfilterrule object has the following properties:

XML / SOAP

Database

Description

condition

condition

[Read-only] One of the following conditions: ct = contains, nc = does not contain, eq = is equal to, ne = is not equal to, bw = begins with, ew = ends with, gt = is greater than, ge = is greater than or equal to, lt = is less than, le = is less than or equal to, in = in the set of.

created

created

[Read-only] Time the record was created. See Date Fields.

field

field

[Read-only] The field or column to be compared.

id

id

[Read-only] Unique ID. Automatically assigned by OpenAir.

required

required

[Read-only] A 1/0 field. 1 = if this condition must be met. 0 = if this is one of many that will satisfy this viewfilter. (If 1, this condition is ANDed with the others. If 0, this condition is ORed with the others.)

type

type

[Read-only] The underlying type of the field or column to be compared: C = character string, N = number, D = date, 'MS' - milliseconds, B = Yes/No, P1 = picker_button, P2 = pop-up menu, 'R' - reference value table.field.

updated

updated

[Read-only] Time the record was last updated or modified. See Date Fields.

value

value

[Read-only] The value the field is compared to.

viewfilterid

viewfilter_id

[Read-only] The viewfilter to which this rule belongs.