SQL query JIRA Boards / Status link

[Janakiraman S]

Hi,

Is there a possibility to query the DB inorder to find associations between boards & statuses linked in column management of a board? If yes, pls suggest how. 

Thanks,

Janaki.

[Earl McCutcheon]

Hello Janakiraman,

This comes up quite often and Using SQL to identify the relationships of the issue data in relation to a board is quite complex, Nic sums it up really well in the following post:

• https://community.atlassian.com/t5/Jira-Core-questions/Link-Jira-Issue-to-Kanban-boards-via-SQL-Database/qaq-p/809487#M35715

  Your database query is, quite simply put, going to be horrid to construct and valid only once per board - you will need to build a new query for every single board, and adjust them as users configure their boards or create new ones.  You'll have to replicate the JQL in SQL (they are very different things) and then apply board settings too. I would strongly suggest that you do NOT try this with SQL.

Your best option is not using SQL queries as they're going to be different for every board, and change all the time.  Use the REST API instead, with something like *GET /rest/agile/latest/board/{Board_ID}/issue*   For a list of all the issues in the board

Additional details on the REST API can be found here

Regards,
Earl