New Request > Template Variables by Request Type

Request Title

{{requestTitle}}

Request Title

• ex) Service DB Access Request

-

Assignees

{{assignees}}

Request Approval Manager

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

-

Comment

{{comment}}

Request Comment

• ex) Requesting database access for service operation purposes.

-

User Name

{{userName}}

Requester’s Name

• ex) Keira Yoon

-

Email

{{email}}

Requester’s Email

• ex) keira@email.com

-

Access Type

{{accessType}}

Request Type

• DB Access Request

• SQL Request

• SQL Export Request

• Unmasking Request

• Server Access Request

• Access Role Request

-

Link

{{link}}

Request Detail Page Link

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

-

Workflow Uuid

{{workflowUuid}}

Request UUID

• ex) b63f9f94-11e5-4095-a399-be7d96e9ce06

-

Workflow Id

{{id}}

Request ID

• ex) 12

-

Urgent

{{urgent}}

Urgency of Request

• true or false

10.2.0

Expiration Date

{{expirationDate}}

Expiration Date

10.2.2

Requested Privilege per Connection

{{connectionPrivilegeNames}}

List of Requested Privileges per Connection

• ex)

  • Connection A : Read/Write

  • Connection B : Read-Only

10.2.2

SQL Text

{{sqlText}}

SQL Statement

• Maximum 100 characters (for both TEXT and FILE)

10.2.2

Content Type

{{contentType}}

Method of SQL 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}}

Database Type

10.2.2

Database Name

{{databaseName}}

Database Name

10.2.2

Use Ledger Approval Rule

{{useLedgerApprovalRule}}

Use of Ledger Approval Rule

10.2.2

Target Date

{{targetDate}}

Target Execution Date

10.2.2

Due Date

{{dueDate}}

Approval/Execution Expiry Date

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}}

Export Type

• QUERY or TABLE

10.2.2

Export Detail

{{exportDetail}}

Export Details

• If Query, up to 100 characters of the query

• If Table, the table name

10.2.2

Target Date

{{targetDate}}

Target Execution Date

10.2.2

Due Date

{{dueDate}}

Approval/Execution Expiry Date

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}}

List of Column Names

• ex) [actor_id, first_name, last_name, last_update]

10.2.2

Unmasking Expiration

{{unmaskingExpiration}}

Unmasking Expiration Time

• ex)

  • 10 Minutes

  • 2024-12-03T14:59:00

10.2.2

Server Group Name

{{serverGroupName}}

Server Group Name

10.2.2

Server Names

{{serverNames}}

List of Server Names

• ex)

  • Server A

  • Server B

10.2.2

Server Accounts

{{serverAccounts}}

List of Server Accounts

• ex)

  • dev

  • ec2-user

10.2.2

Expiration Date

{{expirationDate}}

Expiration Date

10.2.2

Service

{{service}}

Target Service for Role Request

• SAC, KAC, WAC

10.2.2

Role Name

{{roleName}}

Role Name

10.2.2

Expiration Date

{{expirationDate}}

Expiration Date

10.2.2