Role() mvSQL runtime function in Jitterbit App Builder
Summary
Determines if the current user is a member of a given role.
Syntax
ROLE(<role-id-or-name>)
Parameters
role-id-or-name
A string identifying the role, either:
- Role Name - Name of a role belonging to the rule's data source.
- Role Identifier - Unique
RoleIdwhich unambiguously identifies the role across data sources.
Returns
boolean/string
A string value of 1 or 0. A value of 1 indicates that the user is a member of the role; a value of 0 indicates that the user is not a member.
Remarks
The ROLE() function was added in a 2.6 hotfix. The first general release was 2.7.
Examples
ROLE('User')
Returns
'0'
ROLE('6205050b-7ffd-4231-b66c-62106c899d5d')
Returns
'1'