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; } } }

Can I retrieve data from Jira Database using sql instead of jql ?

Jurgen Sërbo

I want to do something like this to make reports easy for me and for my unit.

Accepted answers

Nic Brough -Adaptavist-

No, you don't. Seriously, that is NOT going to "make reports easy".

To perform a full search for JIRA issues matching something, you could have to join the main issue table up to 30 times, and via multi-layered joins. Even a search for a simple custom field is 3 or 4 joins, depending on the type.

SQL is the worst way to do it.

Have a look in the marketplace for reporting add-ons. And maybe tell us what report(s) you are looking for as we might be able to point you at something better.

All comments

Nic Brough -Adaptavist-

No, you don't. Seriously, that is NOT going to "make reports easy".

SQL is the worst way to do it.

Have a look in the marketplace for reporting add-ons. And maybe tell us what report(s) you are looking for as we might be able to point you at something better.

Jurgen Sërbo

Thanks

Nic Brough -Adaptavist-

Tell them they're wrong. You have the support of all of us who've looked at the database!

Jurgen Sërbo

Please, can you suggest me an add-on to use for this porpuse.
Thanx

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira