(1) Table Condition Setting

Set search and sort conditions for the table.
Press the [Search condition] button to bring up the below dialog.


・Set the filter criteria
Set the conditions with fields or by inputting a formula,

Field name

Details

Search condition








[Add] button

Add one search condition

[Delete] button

Delete one search condition

Field

Select a field from the main object to use in the search condition

Reference field

Select a field from the relational object to use in the search condition
※Only selectable if field is set as a Parent-child field or a lookup relation field

Operator

Selectable from below depending on the Field and Reference Field data types.
equals, not equal to, contains, does not contain, <, <=, >, >=

Value

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

Sort Requirement

Add buttonAdd one sort condition
Delete buttonDelete one sort condition
FieldSelect field as sort condition from field list in selected object
OrderSelect field order of Ascending or Descending
Nulls PositionMark if Null value fields should appear at the top or end of the list.
Change sort condition order
Filter LogicSet condition to show record by using added search condition number and separation of AND and OR operators and parentheses.