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.