The query language used with 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 from .
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. You should use simple quotes around strings, and precede quotes within the string with a backslash.
Supported metadata fields on tasks are:
Metadata field |
Description |
---|---|
id (string) |
Task internal identifier |
externalID (string) |
Task external identifier which helps to access a given task from an external system |
currentState (string) |
Current state of the task in the campaign workflow |
assignee (string) |
userId of the data steward currently assigned to this task |
targetTransition (string) |
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) |
Priority level of the task, ranging from 0 (Very Low) to 4 (Very High), default is 2 (Medium) |
dueDate |
Timestamp in milliseconds of the task due date |
matchScore (only for Merging and Grouping campaigns) |
Decimal value which shows the highest match score of each group in the source data |
version (integer) |
Integer value of the task version which is incremented whenever the task is updated |
consumed (boolean) |
true if the task has already been processed (so it cannot be processed anymore - unless it is reopened) |
createdBy (string) |
userId of the task creator |
creationDate (long) |
Timestamp in milliseconds of this task creation date |
lastUpdatedBy (string) |
userId of the data steward who did the last update on the task |
lastUpdateDate (long) |
Timestamp in milliseconds of the last update done on the task |
tags (string) |
List of tags entered by the user for this task |
arbitration (only for Arbitration and Grouping campaigns) |
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. Use simple quotes around strings, and precede quotes within the
string with a backslash.
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 by assignee and have a record field firstname
equal to De'wayne: assignee='user2@talend.com' and
record.firstName='De\'wayne'
To filter tasks created after 2016-01-01: creationDate >
1451659712733
.