GUIDVALUE ER function
The GUIDVALUE function converts the specified input of the String type to a data item of the GUID type.
Syntax
GUIDVALUE (input)
Arguments
input: String
The valid path of a data source of the String type.
Return values
GUID
The resulting globally unique identifier (GUID) value.
Usage notes
To do a conversion in the opposite direction (that is, to convert specified input of the GUID data type to a data item of the String data type), you can use the TEXT function.
Example
You define the following data sources in your model mapping:
- A myID data source of the Calculated field type that contains the expression
GUIDVALUE ("AF5CCDAC-F728-4609-8C8B- A4B30B0C0AA0") - A Users data source of the Table records type that refers to the UserInfo table
You can then use an expression such as FILTER (Users, Users.objectId = myID) to filter the UserInfo table by the objectId field of the GUID data type.