(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 | |
Operator | Selectable from below depending on the Field and Reference Field data types. | |
Value | Input search condition value. Input type will be changed depending on the Field and Reference Field data types. | |
Sort Requirement | ||
Add button | Add one sort condition | |
Delete button | Delete one sort condition | |
Field | Select field as sort condition from field list in selected object | |
Order | Select field order of Ascending or Descending | |
Nulls Position | Mark if Null value fields should appear at the top or end of the list. | |
Change sort condition order | ||
Filter Logic | Set condition to show record by using added search condition number and separation of AND and OR operators and parentheses. |