The DataStore can be used to store an entity set and retrieve it into a job pipeline using a DataStore Reader (as described in the Reader/Writer section above). It is also possible to retrieve a single value directly from the DataStore that can be used in Field Assignments.
The following syntax can be used in a field assignment to retrieve the data.
-
$__STORE(<collection name>, field name>) – Can be used when the DataStore contains 1 row and a single field needs to be retrieved.
-
Collection name – Specifies the name of the table from which the data is read.
-
Field name – The output field to retrieve.
If the DataStore contains more than 1 row, the variables will be resolved using
the last row in the entity set.
-
-
$__STORE(<collection name>, <key field name>, <key value>, <value field name>) – Can be used to retrieve a value from ‘Map’ dataset using a Key.
-
Collection name – Specifies the name of the table from which the data is read.
-
Key field name – The field that contains the key field to the map.
-
Key value – The key value used to identify the row to retrieve.
-
Value field name – The output field to retrieve.
-