nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

sql query to get project list from database

HaRsHaS' V

Hey guys

I am looking to get list of jira projects and the associated agile boards from the database

I would need a sql query as I have the access to database.

Accepted answers

Nic Brough -Adaptavist-

Don't bother with SQL, it's the worst possible way to begin reporting on Jira systems.

You're going to struggle with this question because:

Boards have nothing to do with projects
So you'll need to look at the queries the boards run
Which are stored in a format you will need to parse for "... and project = x ..." or " ... and project in ("x", "y", "z") if you want to associate them directly with projects
And worry about queries that are not tied to projects (3/4 of the boards I use regularly have no project clause - in our system, you would have to assume "most of Nic's boards cover every project"

Jira's searches and REST API can make this very easy for you. Don't try it in SQL, you won't like it.

All comments

Nic Brough -Adaptavist-

Don't bother with SQL, it's the worst possible way to begin reporting on Jira systems.

You're going to struggle with this question because:

Boards have nothing to do with projects
So you'll need to look at the queries the boards run
Which are stored in a format you will need to parse for "... and project = x ..." or " ... and project in ("x", "y", "z") if you want to associate them directly with projects
And worry about queries that are not tied to projects (3/4 of the boards I use regularly have no project clause - in our system, you would have to assume "most of Nic's boards cover every project"