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.

Table Grid Editor (legacy) Documentation

Exporting Table Grid data for multiple issues

Analytics

Introduction

Solution

Related content