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()`	—	—

—

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 SuiteProjects Pro.
`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.

XML / SOAP

Database

Description

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

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

field

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

id

[Read-only] Unique ID. Automatically assigned by SuiteProjects Pro.

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

[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

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

value

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

viewfilterid

viewfilter_id

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