Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.