(1) Table Condition Setting

Set search and sort conditions for the table.

Displays "Table Condition Setting" dialog from the "Where Clouse Filter" property.


Table Condition Setting

Select fields and conditions, and set search and sort criteria.

Field NameDetails
Search Requirement Field

[Add] button

Add one search condition

You can add up to 30 items

[✖] button

Delete one search condition

No.

Display the number

Field

Select a field from the Object to use in the search condition

Please refer to < (1)-b. Conditional Item Data Type >

Operator

Selectable from below depending on the Field and Reference Field data types

Please refer to < (1)-b. Conditional Item Data Type >


Equals
Not Equals
Includes
Excludes
Less Than
Less Than Or Equal To
Greater Than
Greater Than Or Equal To

Value

Input search condition value. Input type will be changed depending on the Field and Reference Field data types

Please refer to < (1)-b. Conditional Item Data Type >

Filter Logic

Display the search conditions as an expression separated by [No.] and [AND]

Sort Requirement

[Add] button

Add one sort condition

You can add up to 30 items

[✖] button

Delete one sort condition

No.

Display the number

Field

Select field as sort condition from field list in selected object

Please refer to < (1)-b. Conditional Item Data Type >

Order

Select field order of Ascending or Descending

Null Position

Mark if Null value fields should appear at the top or end of the list

Change sort condition order.