Filter and Condition

Filtering

In DragOnce platform, we provide a record filter feature for users to keep the wanted record(s). 

Filtering or other functions which need condition will only be performed when the condition result is TRUE. 

Component

Case 1

In Case 1, there are two conditions: (Widget A >= Filter Value) and (Widget B >= Filter Value). While these conditions are using the operator “and” , the table will filter out records that fulfil BOTH conditions.

*Filter Value = 2

For the first condition, (Widget A >= Filter Value), record 3, 5, 6 and 8 fulfilled the first condition. Therefore all of these 4 records will be filtered out and go to the second condition. 

For the second condition, (Widget B >= Filter Value), all records 3, 5, 6 and 8 fulfill the second condition. 

Records 3, 5, 6 and 8 are the records that fulfill both conditions and they will be filtered out. 

Case 2

In Case 2, there are two conditions: (Widget A >= Filter Value) or (Widget B >= Filter Value). While these conditions are using the operator “or”, the table will filter out a record that fulfills EITHER one condition. 

For the first condition, (Widget A >= Filter Value), record 3, 5, 6 and 8 fulfilled the first condition. 

For the second, (Widget B >= Filter Value), record 3, 4, 5, 6 and 8 fulfilled the second condition. 

Since record 3, 4, 5, 6 and 8 fulfilled either one condition, therefore all of these 5 records will be filtered out.  

Case 3

In Case 3, there are 3 conditions: (Widget A >= Filter Value) and (Widget B >= Filter Value) and (Widget C >= Filter Value and Widget D >= Filter Value). Records that fulfill all three conditions can be filtered out. 

For the first condition, (Widget A >= Filter Value), only records 3, 5, 6 and 8 are fulfilled. Therefore only these records will be filtered out and go to the second condition.

For the second condition, (Widget B >= Filter Value), all records 3, 5, 6 and 8 are fulfilled. Therefore all of these 4 records will be filtered out and go to the third condition. 

For the third condition, (Widget C >= Filter Value and Widget D >= Filter Value), there are 2 parts connected with the operator “and” which means a record fulfilling both parts can be filtered out. 

• In the first part, (Widget C>= Filter Value), records 3, 5 and 6 are fulfilled. 

• In the second part, (Widget D>= Filter Value), records 3, 5, and 6 are fulfilled. 

Since only record 3, 5 and 6 fulfilled both parts of the condition, therefore only these three records will be filtered out. 

Case 4

In Case 4, there are 3 conditions: (Widget A >= Filter Value) and (Widget B >= Filter Value) and (Widget C >= Filter Value or Widget D >= Filter Value). Records that fulfill all three conditions can be filtered out.

For the first condition, (Widget A >= Filter Value), only records 3, 5, 6 and 8 are fulfilled. Therefore only these records will be filtered out and go to the second condition.

For the second condition, (Widget B >= Filter Value), all records 3, 5, 6 and 8 are fulfilled. Therefore all of these 4 records will be filtered out and go to the third condition. 

For the third condition, (Widget C >= Filter Value or Widget D >= Filter Value), there are 2 parts connected with the operator “or” which means a record that fulfills either one part can be filtered out. 

• In the first part, (Widget C >= Filter Value),  records 3, 5, and 6 are fulfilled.

• In the second part, (Widget D >= Filter Value), all records 3, 5, 6 and 8 were fulfilled.  

Since all records 3, 5, 6 and 8 fulfill either one part of the condition, therefore all of these 4 records will be filtered out. 

Case 5

In Case 5, there are 3 conditions: (Widget A >= Filter Value) or (Widget B >= Filter Value) or (Widget C >= Filter Value and Widget D >= Filter Value). Records that fulfill either one condition can be filtered out.

For the first condition, (Widget A >= Filter Value), records 3, 5, 6 and 8 are fulfilled. 

For the second condition, (Widget B >= Filter Value), record 3, 4, 5, 6 and 8 fulfilled. 

For the third condition, (Widget C >= Filter Value and Widget D >= Filter Value), there are 2 parts connected with the operator “and” which means a record that fulfills both parts can be filtered out. 

• In the first part, (Widget C >= Filter Value), records 3, 4, 5, 6 and 7 are fulfilled. 

• In the second part, (Widget D >= Filter Value), records 2, 3, 4, 5, 6, 7 and 8 are fulfilled.

Therefore, in the third condition, only records 3, 4, 5, 6 and 7 are filtered out. 

To sum up, records 3, 4, 5, 6, 7 and 8 fulfilled either one condition and these records will be filtered out. 

Case 6

In Case 6, there are 3 conditions: (Widget A >= Filter Value) or (Widget B >= Filter Value) or (Widget C >= Filter Value or Widget D >= Filter Value). Records that fulfill either one condition can be filtered out. 

For the first condition, (Widget A >= Filter Value), records 3, 5, 6 and 8 are fulfilled. 

For the second condition, (Widget B >= Filter Value), record 3, 4, 5, 6 and 8 fulfilled. 

For the third condition, (Widget C >= Filter Value or Widget D >= Filter Value), there are 2 parts connected with the operator “or” which means a record that fulfills either part can be filtered out.

• In the first part, (Widget C >= Filter Value), records 3, 4, 5, 6 and 7 are fulfilled.

• In the second part, (Widget D >= Filter Value), records 2, 3, 4, 5, 6, 7 and 8 are fulfilled. 

Therefore, in the third condition, record 2, 3, 4, 5, 6, 7 and 8 have fulfilled either one part. 

To sum up, records 2, 3, 4, 5, 6, 7 and 8 fulfill either one condition and these records will be filtered out. 

Case 7

In Case 7, there are 4 conditions: (Widget A >= Filter Value) and (Widget B >= Filter Value) and (Widget C >= Filter Value and Widget D >= Filter Value) and (Widget E >= Filter Value and Widget F >= Filter Value). Records that fulfill all four conditions can be filtered out. 

For the first condition, (Widget A >= Filter Value), record 3, 5, 6 and 8 fulfilled the condition. Therefore these four records will be filtered out and go to the second condition. 

For the second condition, (Widget B >= Filter Value), all records 3, 5, 6 and 8 fulfilled the condition. These four records will be filtered out and go to the third condition. 

For the third condition, (Widget C >= Filter Value and Widget D >= Filter Value), record 3, 5 and 6 fulfilled both parts. Therefore these three records will be filtered out and go to the fourth condition.

For the fourth condition, (Widget E >= Filter Value and Widget F >= Filter Value), there are two parts connected with the operator “and” which means a record that fulfills all parts can be filtered out. 

• In the first part, (Widget E >= Filter Value), records 3 and 5 are fulfilled.

• In the second part, (Widget F >= Filter Value), records 3 and 6 are fulfilled. 

Therefore, in the fourth condition, only record 3 fulfilled both parts. 

To sum up, record 3 fulfilled all four conditions and it will be filtered out. 

Case 8

In Case 8, there are 4 conditions: (Widget A >= Filter Value) and (Widget B >= Filter Value) and (Widget C >= Filter Value and Widget D >= Filter Value) and (Widget E >= Filter Value or Widget F >= Filter Value). Records that fulfill all four conditions can be filtered out. 

For the first condition, (Widget A >= Filter Value), record 3, 5, 6 and 8 fulfilled the condition. Therefore these four records will be filtered out and go to the second condition. 

For the second condition, (Widget B >= Filter Value), all records 3, 5, 6 and 8 fulfilled the condition. These four records will be filtered out and go to the third condition. 

For the third condition, (Widget C >= Filter Value and Widget D >= Filter Value), record 3, 5 and 6 fulfilled both parts. Therefore these three records will be filtered out and go to the fourth condition.

For the fourth condition, (Widget E >= Filter Value or Widget F >= Filter Value), there are two parts connected with the operator “or” which means a record that fulfills either part can be filtered out. 

• In the first part, (Widget E >= Filter Value), records 3 and 5 are fulfilled.

• In the second part, (Widget F >= Filter Value), records 3 and 6 are fulfilled. 

Therefore, in the fourth condition, record 3, 5 and 6 fulfilled either one part. 

To sum up, record 3, 5 and 6 fulfilled all four conditions and it will be filtered out. 

Case 9

In Case 9, there are 4 conditions:  (Widget A >= Filter Value) and (Widget B >= Filter Value) and (Widget C >= Filter Value and Widget D >= Filter Value) and (Widget E >= Filter Value or Widget F >= Filter Value). Records that fulfill all four conditions can be filtered out. 

For the first condition, (Widget A >= Filter Value), record 3, 5, 6 and 8 fulfilled the condition. Therefore these four records will be filtered out and go to the second condition. 

For the second condition, (Widget B >= Filter Value), all records 3, 5, 6 and 8 fulfilled the condition. These four records will be filtered out and go to the third condition. 

For the third condition, (Widget C >= Filter Value or Widget D >= Filter Value), record 3, 5, 6 and 8 fulfill either part of the condition. These four records will be filtered out and go to the fourth condition. 

For the fourth condition, (Widget E >= Filter Value and Widget F >= Filter Value), there are two parts connected with the operator “or” which means a record that fulfills both parts can be filtered out. 

• In the first part, (Widget E >= Filter Value), records 3 and 5 are fulfilled.

• In the second part, (Widget F >= Filter Value), records 3 and 6 are fulfilled. 

Therefore, in the fourth condition, only record 3 fulfilled all parts. 

To sum up, record 3 fulfilled all four conditions and it will be filtered out. 

Case 10

In Case 10, there are 4 conditions:  (Widget A >= Filter Value) and (Widget B >= Filter Value) and (Widget C >= Filter Value or Widget D >= Filter Value) and (Widget E >= Filter Value or Widget F >= Filter Value). Records that fulfilled all four conditions can be filtered out. 

For the first condition, (Widget A >= Filter Value), record 3, 5, 6 and 8 fulfilled the condition. Therefore these four records will be filtered out and go to the second condition. 

For the second condition, (Widget B >= Filter Value), all records 3, 5, 6 and 8 fulfilled the condition. These four records will be filtered out and go to the third condition. 

For the third condition, (Widget C >= Filter Value or Widget D >= Filter Value), record 3, 5, 6 and 8 fulfill either part of the condition. These four records will be filtered out and go to the fourth condition.

For the fourth condition, (Widget E >= Filter Value and Widget F >= Filter Value), there are two parts connected with the operator “or” which means a record that fulfills both parts can be filtered out. 

• In the first part, (Widget E >= Filter Value), records 3 and 5 are fulfilled.

• In the second part, (Widget F >= Filter Value), records 3 and 6 are fulfilled.

Therefore, record 3, 5 and 6 fulfilled either one part of the condition.

To sum up, record 3, 5 and 6 fulfilled all four conditions and these records will be filtered out.

How to set Filtering

Filtering exists in Data Retrieval, Triggering Methods & Condition Checking. For example, Table Data Source Setting, Page Data Source Setting, Cascading Workflow Triggering, Calculation, Visibility, etc. And, the setting in different locations is similar. 

1. Click Add Condition to add a single filtering rule.

2. Hover the Left-Hand-Side Variable, and select the Filtering Operand from Data Source.

3. Select the Operator.

4. Hover the Right-Hand-Side Variable, and select the Filtering Operand from Page.

General Controls of a Condition

When you mouse over the left-hand-side (LHS) or right-hand-side (RHS) field, parameter buttons will pop up. Click to open the list of parameters you can choose. 

The LHS parameter must be filled before the RHS parameter can be filled. What is chosen on the LHS will affect the number of options you can select in the condition operator and the RHS parameter. 

When a controller parameter (Know More: Controller Parameter) is chosen on the RHS, 

Definitions of predefined variables in the system:

Possible widgets available from the widget parameter list:

• Input Box

• AutoComplete

• Selection Box

• Dropdown Menu

• Date & Time

• User & Group

• File Uploader

• Image Uploader

• Label

• Attachment

After you click the ‘Text’ button, you can type text, number or symbol in the input box and click apply. 

After you click the ‘Date’ button, a calendar will pop up. You can click ‘AM’ once to change it to ‘PM’. By clicking the ‘Clock’ button on the left of the ‘Confirm’ button, the calendar shows you the current date and time. After finishing, click ‘Confirm’. 

Options parameters are user-defined variables. Their values are previously inputted by a user or App designer. 

For example, if a dropdown menu is chosen as the LHS parameter, all options in the dropdown menu widget will be available for selection as options parameters. Similarly, if workflow state is chosen as the LHS parameter, all workflow states in the workflow of the form will be available for selection as options parameters.

After you click the ‘User Picker’ button, you can choose a user or group from the user and group list. After finishing, click ‘Apply’. 

Condition Operator

The following table shows all condition operators.