Retriving all issue in project via database query

Jordan Berry

I am trying to get all of the issues in 2 projects through the database (Postgresql). I would like to get about 20 fields, some system and some custom. I am relatively new to writing these queries, so I am not exactly sure what to look for. 

The reason I am trying to do this, is between 2 projects we have roughly 10,000 issues, and I need to do a mass export to get into a separate list to query against. This would allow users in these projects to have an easier time searching through their data, as they are finding the built in search/jql too confusing (and complex due to our custom fields)

Does anyone have an example query I can reference that shows how to select a project and multiple fields?

 

Nic Brough -Adaptavist-

This is the worst possible way to get data out of Jira. 

Jiraissue is a table containing issues.  You need to join it to the project table, then a pile of tables that relate to understanding the system fields attached to an issue, then at least 2 (and potentially hundreds) more joins to understand each custom field. 

Where your users are finding JQL "too confusing", they're going to find SQL thousands of times more confusing and horrendously slower.

Please, get them to work with JQL.  And if your custom fields still confuse them after you've got them working with the basics, then you really need to do something about your custom fields being over-bearing.