Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

This article describes how to use placeholders in combination with SQL to specify a data source for a grid.  Table Grid Next Generation supports placeholders to query Jira values.Jira values can be used to populate the grid with data from Jira objects.

You can query the values from the following Jira-specific objects: issue, project, component, user and custom fields.

For example, you can populate the grid column with a default value retrieved from Jira object. 

You can use Jira values to populate the grid with data in different cases:

  • initialize grid with data 
  • set default values for gird columns
  • populate select lists with dynamic options retrieved from Jira
  • use custom field values in a grid: get data from a custom field which has a list of values and populate a grid with these values.

Supported values

Basic Jira Values

Issue Level specificProject Level specificCurrent User Level specific
  • issue/parent
    • id
    • key
    • summary
    • environment
    • estimate
    • logged
    • description
    • created_date
    • resolution_date
    • updated_date
    • due_date
    • votes
    • watches
    • security_level
  • status
    • id
    • name (default)
    • description
    • sequence
  • status_category
    • id
    • name (default)
    • key
    • sequence
  • resolution
    • id
    • name (default)
    • description
    • sequence
  • priority
    • id
    • name (default)
    • description
    • sequence
  • type
    • id
    • name (default)
    • description
    • sequence
  • assignee
    • id
    • key
    • name (default)
    • full_name
    • email
    • email_domain
  • reporter
    • id
    • key
    • name (default)
    • full_name
    • email
    • email_domain
  • components
      • id
      • name (default)
      • description
  • fix_versions
    • id
    • name (default)
    • description
  • affected_versions
    • id
    • name (default)
    • description
  • labels
    • id
    • name (default)
  • attachments
    • id
    • name (default)
    • file_size
  • project
    • id
    • key
    • name
    • url
    • description
  • category
    • id
    • name (default)
    • description
  • lead
    • id
    • key
    • name (default)
    • full_name
    • email
    • email_domain
  • components
      • id
      • name (default)
      • description
      • lead_name
  • versions
    • id
    • name (default)
    • description
    • is_archived
    • is_released
    • release_date
    • start_date
  • current_user
    • id
    • key
    • name (default)
    • ull_name
    • email
    • email_domain


Example placeholders for basic Jira values

Below you can find some example of the placeholders with the queries


select name,price from sandwich_menu where restaurant={customfield:10010}

Custom Field Values

Single Value types

  • Date (should be treated as dates in our date column types)
    • Date Picker
    • Date Time Picker
  • Numeric (should be treated as dates in our date column types)
    • Number Field
  • All other custom fields without a specific type should be handled the same way - get custom field value as a string

Multi-Value types

  • Checkboxes
  • Labels
  • Radio Buttons
  • Select List (cascading)
  • Select List (multiple choices)
  • Group Picker (multiple groups)
  • User Picker (multiple users)
  • Version Picker (multiple versions)


Example placeholders for custom field values


customfield:{id}


example
customfield:12345 // retreives data from the custom field with id 12345


  • No labels