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

How to connect JIRA Filter to results in sql ?

Manoj Kumar_nh13i5

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

Accepted answers

Nic Brough -Adaptavist-

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

All comments

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

Nic Brough -Adaptavist-

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_nh13i5

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.

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

jira-server