The query language used with Talend Data Stewardship components

EnrichVersion
6.4
EnrichProdName
Talend Data Fabric
Talend Big Data
Talend Data Services Platform
Talend Real-Time Big Data Platform
Talend MDM Platform
Talend ESB
Talend Big Data Platform
Talend Data Management Platform
Talend Data Integration
task
Design and Development > Third-party systems > Data Stewardship components
Data Quality and Preparation > Third-party systems > Data Stewardship components
Data Governance > Third-party systems > Data Stewardship components
EnrichPlatform
Talend Data Stewardship
Talend Studio

The query language used with Talend Data Stewardship components

You can use a query language with the tDataStewardshipTaskDelete and tDataStewardshipTaskInput components to query and filter the data you want to delete or read on the Talend Data Stewardship server.

The query statement used to filter tasks on the server is composed of one or several conditions. You can combine or negate conditions using the boolean operators and and or, or the not operator respectively. Parenthesis are supported to override default boolean precedence.

A task condition is composed of a field name, an operator and a value.

Supported metadata fields on tasks are:

Metadata field

Description

id (string)

the task internal identifier

currentState (string)

the current state of the task in the campaign workflow

assignee (string)

the userId of the data steward currently assigned to this task

targetTransition (string)

the name of the transition chosen by user to move the task to the next step in the campaign workflow

completed (boolean)

true if the task is completed (it is in a final state of the workflow)

priority (integer)

the priority level of the task, ranging from 0 (Very Low) to 4 (Very High), default is 2 (Medium)

consumed (boolean)

true if the task has already been processed (so it cannot be processed anymore - unless it is reopened)

createdBy (string)

the userId of the task creator

creationDate (long)

the timestamp in milliseconds of this task creation date

lastUpdatedBy (string)

the userId of the data steward who did the last update on the task

lastUpdateDate (long)

the timestamp in milliseconds of the last update done on the task

tags (string[])

the list of tags entered by the user for this task

arbitration (for arbitration campaigns only)

the arbitration choice selected by the data steward

When referencing records data, the name of the field must be prefixed by record.. Simple binary operators are =, <, >, <=, >= and !=. The third part of the condition can be any literal value, strings must be put between simple quotes.

To filter tasks by assignee and have a record field firstname equal to John: assignee='user1@talend.com' and record.firstName='John'

To filter tasks created after 2016-01-01: creationDate > 1451659712733.