New Request > Template Variables by Request Type

Request Title

{{requestTitle}}

Title of the request

• Example: Service DB Access Request

-

Assignees

{{assignees}}

Approvers for the request.

• Example: STEP 1(Katie Wells), STEP 2(Kenny Park), STEP 3(Brant Hwang)

-

Comment

{{comment}}

Comment for the request

• Example: Requesting DB access for service operation purposes.

-

User Name

{{userName}}

Name of the requester

• Example: Keira Yoon

-

Email

{{email}}

Email of the requester

• Example: keira@email.com

-

Access Type

{{accessType}}

Type of the request

• DB Access Request

• SQL Request

• SQL Export Request

• Unmasking Request

• Server Access Request

• Access Role Request

-

Link

{{link}}

Link to the request detail page

• Example: https://{querypie_domain}/workflow/received-requests/to-do/detail/{workflow_uuid}

-

Workflow Uuid

{{workflowUuid}}

UUID of the request

• Example: b63f9f94-11e5-4095-a399-be7d96e9ce06

-

Workflow Id

{{id}}

ID of the request

• Example: 12

-

Urgent

{{urgent}}

Indicates if the request is urgent

• true or false

10.2.0

Expiration Date

{{expirationDate}}

Expiration date of the access.

10.2.2

Requested Privilege per Connection

{{connectionPrivilegeNames}}

Displays the requested privileges for each connection as a list

• Example:

  • Connection A : Read/Write

  • Connection B : Read-Only

10.2.2

SQL Text

{{sqlText}}

The SQL statement

• Max 100 characters, applies to both TEXT and FILE input methods

10.2.2

Content Type

{{contentType}}

SQL statement input

• TEXT or FILE

10.2.2

Cluster Group Uuid

{{clusterGroupUuid}}

DB Connection UUID

10.2.2

Cluster Group Name

{{clusterGroupName}}

DB Connection Name

10.2.2

Cluster Id

{{clusterId}}

DB Connection ID

10.2.2

Database Type

{{databaseType}}

Type of the database

10.2.2

Database Name

{{databaseName}}

Name of the database

10.2.2

Use Ledger Approval Rule

{{useLedgerApprovalRule}}

Indicates if the ledger approval rule is used

10.2.2

Target Date

{{targetDate}}

Target date for execution

10.2.2

Due Date

{{dueDate}}

Due date for approval/execution

10.2.2

Cluster Group Uuid

{{clusterGroupUuid}}

DB Connection UUID

10.2.2

Cluster Group Name

{{clusterGroupName}}

DB Connection Name

10.2.2

Cluster Id

{{clusterId}}

DB Connection ID

10.2.2

Database Type

{{databaseType}}

Database Type

10.2.2

Database Name

{{databaseName}}

Database Name

10.2.2

Export Type

{{exportType}}

Type of export

• QUERY or TABLE

10.2.2

Export Detail

{{exportDetail}}

Details of the export

• If Query, max 100 characters of the query

• If TABLE the name of the table

10.2.2

Target Date

{{targetDate}}

Target date for execution

10.2.2

Due Date

{{dueDate}}

Due date for approval/execution

10.2.2

Cluster Group Uuid

{{clusterGroupUuid}}

DB Connection UUID

10.2.2

Cluster Group Name

{{clusterGroupName}}

DB Connection Name

10.2.2

Database Type

{{databaseType}}

Database Type

10.2.2

Database Name

{{databaseName}}

Database Name

10.2.2

Table Name

{{tableName}}

Table Name

10.2.2

Column Names

{{columnNames}}

Displays column names as a list

• Example: [actor_id, first_name, last_name, last_update]

10.2.2

Unmasking Expiration

{{unmaskingExpiration}}

Expiration time for unmasking

• Example:

  • 10 Minutes

  • 2024-12-03T14:59:00

10.2.2

Server Group Name

{{serverGroupName}}

Name of the server group

10.2.2

Server Names

{{serverNames}}

Displays server names as a list

• Example:

  • Server A

  • Server B

10.2.2

Server Accounts

{{serverAccounts}}

Displays server accounts as a list

• Example:

  • dev

  • ec2-user

10.2.2

Expiration Date

{{expirationDate}}

Expiration date of the access

10.2.2

Service

{{service}}

The service for which the role is being requested

• SAC, KAC, WAC

10.2.2

Role Name

{{roleName}}

Name of the Role

10.2.2

Expiration Date

{{expirationDate}}

Expiration date of the role

10.2.2