Workday Connector > Creating a Workday Synchronization Task > Data Filters
  

Data Filters

Data filters help you to fetch specific data of a particular object. The synchronization task will process the data based on the filter field assigned to the object.
The following steps help you to use data filters.
    1In a synchronization task, select the Data Filters tab.
    2Click New as shown in the following figure:
    The Data Filter dialog box appears:
    3Specify the following details:
    Field Type
    Description
    Object
    Select Object for which you want to assign filter fields.
    Filter By
    Select the Filter Field.
    Operator
    Select Equals operator.
    Filter Value
    Enter the Filter value.
    4Click Ok.
    Note: In the current release, only Equals operator is supported by Workday connector.
    For example, Process a series of 200 rows using RecordCount field.
    5Select RecordCount as the filter field.
    6Select operator Equals.
    7Enter the filter value according to the required series to process:
    8Click Ok.
Therefore, data up to only a series of rows is processed.

Advanced Data Filters

Advanced data filter supports complex expression in Workday Connector.
Perform the following steps to configure an advanced data filter in a synchronization task:
  1. 1In the Data Filter dialog box, click Advanced.
    2. The Advanced Data Filter dialog box appears.
  2. 2Enter the Filter Expression in the following syntax format:
    3. Field1<Operator1>Value1; Field2<Operator2>Value2
    Where, Field1 and Field2 are Workday fields, Operator 1 and Operator 2 are operators supported for filter expression, Value1 and Value 2 are corresponding values.
    The figure below displays an example of Advanced Data Filter Expression:
  3. 3Click OK.
You can also specify the value for the SourceFilter field in the filter expression by performing the following steps:
  1. 1On the Schedule tab, select Advanced Source Properties.
  2. 2Specify the Filter Expression value in the SourceFilter field.
    3. This enables filter to be stored in a session.

Get Incremental Updates

To get incremental updates, Enter UpdatedFromDateTime as the $LastRunTime and run the task. The incremental update fetches a number of records added between the last success run time and current run time of the task.
The following steps help you to get incremental updates
    1On the Data Filters tab, click New.
    The Data Filter dialog box appears.
    2Select the Object.
    3Select UpdatedFromDateTime as the filter field.
    4Select Operator Equals.
    5Enter the filter value "$LastRunTime".
Now, you will get incremental updates of data.
Note: Incremental update is only applicable to objects that contain UpdatedFromDateTime field.