Accessing DataStore Variables - EcoSys - 3.0 - Help - Hexagon PPM

EcoSys Connect Help

Language
English
Product
EcoSys
Search by Category
Help
EcoSys Version
3.0

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.