How to connect JIRA Filter to results in sql ?

[Manoj Kumar]

Hi Team,

            I am looking to find the join between a saved jira filter and issuekey/issueid in db. Where can I find the mapping ?

Right now I am seeing join between SEARCHREQUEST and PROJECT table but not to the issueid.

Can someone please help me with this.

Regards,

Manoj

[Nic Brough -Adaptavist- · Accepted solution]

That "mapping" is done in the application, not the database, so you will not find it with SQL.

You should stop reading the database for this and try to use Jira properly

[Manoj Kumar]

Heyy Nic,

               Thanks for your reply. Just wanted to know if that's possible. We are using it properly and we have scripts to pull the data under filters using api. But it's taking a lot of time ,so wanted to check if anything can be done using database rather than api's.

[Nic Brough -Adaptavist-]

You will find the database slower and a lot more fragmented than the APIs.  "Read an issue" for example is one single API call, but would need 18 joins in SQL just for the basics, going up into the hundreds for a more customised Jira system.

[Chihara]

This simple SQL shows issueid, issuekey (prj.pky + ji.issuenum)
select ji,ID, prj.pkey, ji.issuenum from jiraissue ji, project prj where prj.ID=ji.Project