Data Item

Data items are the result units of database queries. Currently they are only produced by a set of Salesforce commands that retrieve record data, and in that context each data item represents one record of a query result.

The features of Data items are mostly the same as those of Map values - a Data item is basically an extension of a Map. Each queried field appears as a map entry, with the field's API name as the entry's key and the field's value as the entry's value. Therefore any value in a Data item can be accessed with expressions of the kind "${record.field}", eg. "${Opportunity.Amount}". As the Salesforce fields can be of various types, so do the values of these fields inside the Data items represent various types as well. Below is a table describing the relations between the fields and Dynamo's value types.

Salesforce field type Dynamo value type
Number Number
Currency Currency
Date Date
Date/Time DateTime
Percent Percentage
Picklist Picklist Value
Picklist (Multi-Select) Multipicklist Value
HTML-formatted value / Rich text HTML Value
Other field types String

Should the query generating the Data item contain fields of referenced records, eg. "Opportunity.Account.Name", the Data items of those referenced records actually appear inside the base Data item. So in the case of  "Opportunity.Account.Name", the resulting base Data item would be for Opportunity, but it would contain another Data item for the Account as the value for the key "Account", and so the expression "${Opportunity.Account.Name}" will access the Account Data item from which it retrieves the Name value.

If a record has an undefined/blank value for a field, that field's value will appear in a Data item as null, regardless of the field's type.  


Being an extension of the Map value type, Data item has all the methods of Map in addition to the ones listed here.

getObjectType() Resolves into a String that is the API name of the object the record represents.

For example, if 'resultRecord' is a Data item produced by a Dynamo clause query, ${resultRecord.getObjectType()} might return "Dynamo_Clause__c".

Using the shorthand form the expression becomes ${resultRecord.objectType}.