Data Filter

Introduction

Functions

Data filter can support to filter data. It can filter data that do not need to be processed and maintain data that needs to be processed.

Application Scenarios

In students' scores management, you can filter the students' scores in class 1 and calculate its average score.
In employees management, you can filter employees whose gender is female and add up the number of female employees.

Preview

Here is an example of filtering students' scores in class 1.

Setting Procedure

Where to Set

Add the input form, drag and drop Data Filter from the left side to the data processing page, and add the connector between the Students Score form and Data Filter. Click Data Filter and you can set in Node Configuration.

Adding Filter Conditions

Click Add Condition and set the condition as Class equals to Class 1.

Supported Fields

Filter conditions can support the following fields:

Field Types	Supported Fields
Line Type	Single Line Multi Line Single Select Multi Select Radio Checkbox Serial No. Workflow status in system fields Extended fields in system fields Line fields from calculated fields
Date&Time Type	Data&Time fields in forms Created time of system fields Updated time of system fields
Image and Attachment Type	Image Attachment Signature
Member Type	Member Members Created user in system fields
Department Type	Department Departments

All fields that are supported by main forms are also supported by sub forms.

Demonstration

For details about the effect of the data filter, see the section"Preview".

Note

1. One data filter node can support to add multiple conditions. It also supports to set relationships between filter conditions(intersection or union).

2. You can add no filter condition, which will output all data.