Skip to Content

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 RoleId which 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'