/
Exporting Table Grid data for multiple issues
Exporting Table Grid data for multiple issues
Introduction
You can export the Table Grid data for a single issue or for an entire set of issues. How to export the data for multiple issues?
For example, export a set of issues to see all table grid entries where project = MYPROJECT.
Solution
You will need access to the database where the grid table is stored.
Assume that your grid table is called actions_c10123 and is stored in the same database as JIRA then you can export the table rows using a query like below:
select gridtable.*
from actions_c10123 gridtable
inner join jiraissue ji on gridtable.issueid = ji.id
inner join project p on ji.project = p.id
where p.pname = 'MYPROJECT'
The name of the gridtable and the database where the gridtable is stored can be configured through the properties gd.tablename and gd.ds.
, multiple selections available,
Related content
How to export data from grid
How to export data from grid
More like this
Extract Information from the Grid using the Java API
Extract Information from the Grid using the Java API
More like this
Query Jira values to add dynamic grid data
Query Jira values to add dynamic grid data
More like this
Table Grid Next Generation for Jira Cloud
Table Grid Next Generation for Jira Cloud
More like this
Table Grid Next Generation Server / Datacenter Documentation
Table Grid Next Generation Server / Datacenter Documentation
More like this
Table Grid Editor (legacy) for Jira Server Documentation
Table Grid Editor (legacy) for Jira Server Documentation
More like this