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.