Populate the grid with dynamic data from Jira objects using Jira values placeholders.
Introduction
You can query data from Jira using Jira values placeholders. For example, by initializing the grid with some default data when the user creates an issue.
Table Grid Next Generation allows you to populate a grid with data based on the values from Jira fields.
These values are used when the grid is initialized for a specific issue or when the grid query is refreshed. You can get issue-specific values with the help of placeholder queries.
Jira values placeholders allow you to manipulate dynamic data in a Jira issue. This data can be either data from the external database or from your Jira database.
Configuration
Let's create a grid and name it Licenses.
Then add the following columns:
- Company: string column with the default value set dynamically using the value from the custom field Company name
- Sold by: string column with the default value set dynamically based on the current issue assignee
- Licenses: single select list with the dynamic options that use an external data source.
The query filters data depending on values from custom fields Company size and License type.
- Discount: Single select list with static options
- Price: Formula column which calculates the final price including discount
Result
Set default column values based on the value from another Jira issue field
On the issue view screen in Jira there's a grid with some default values. These default values are set based on the values from different Jira fields.
Check the example below with the grid columns populated with values from other Jira issue fields:
- Company column value in the grid is set automatically based on the value of the Company Name custom field
- Sold by column value is using the value from the issue assignee field
Filter out the grid data depending on the value from another Jira field
Another example is where you can filter out the grid data depending on the value from another Jira field using Jira values placeholders.
The grid has dynamic options in a select list column. Option values are queried from the external data source.
Using Jira values placeholder inside, the query filters data depending on values from custom fields Company size and the License type.
You can see that placeholders use certain syntax.
Check Jira values placeholder syntax and examples for more details.
In the grid on the issue view, the price is calculated based on the following Jira and grid values
- custom field Company Size
- custom field License type
- option selected in the Licenses column
- the discount in the Discount column.
All calculations are done with the help of the grid formula.
Below you can see the issue view with custom fields and grid values.
