Filter Dialog
Expression Grid
| Column | Description |
|---|---|
| Logic | Select the logical conjunction to be used to combine the expressions from the dropdown |
| Column Name | Select the column name on which the filter is to be applied from the dropdown |
| Condition | Select the conditional operator to be used in the expression from the dropdown |
| Value | Specify the Value of the selected column to filter |
Logical Conjunctions
| Option | Description |
|---|---|
| AND | Performs logical AND operation between the fixed terms |
| OR | Performs logical OR operation between the fixed terms |
Filter
Using this, users can build and apply the filter criteria to read, edit & delete the specific list items. Click on the Filter button available as part of the body of List activities to create your filter expressions. Column Names change based on the selected List.
Number of items
Apply filter by setting the Number of list items to be fetched, satisfying the specified filter condition.
note
Number of items will be considered only for Read Lists activity.
Building filter expressions
- Click on the + button available in the dialog
- Select the column name from the dropdown and apply the filter to the record.
- Select the conditional operator from the dropdown
- Specify the Value to be used for the filter
tip
To compare against the null values, DBNull.Value has to be provided as Value.
You can build complex expressions by adding more expressions combined with appropriate conjunctions.
- Click on the + button
- Select the conjunction from the dropdown
- Continue building expressions