Skip to main content
Skip table of contents

New Request > Template Variables by Request Type

When selecting New Request as the Alert Type, the template variables supported by each Request Type are as follows.

Common Variables

This is a list of variables supported by all request types.

Common variables can be used even when selecting all Request Types.

Variable Name

Variable

Description

Added Version

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

-

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

DB Access Request

Variable Name

Variable

Description

Added Version

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 Request

Variable Name

Variable

Description

Added Version

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

SQL Export Request

Variable Name

Variable

Description

Added Version

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

Unmasking Request

Variable Name

Variable

Description

Added Version

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 Access Request

Variable Name

Variable

Description

Added Version

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

Access Role Request

Variable Name

Variable

Description

Added Version

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.