(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 Name | Details | |
---|---|---|
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 | |
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. |