Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to connect JIRA Filter to results in sql ?

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

2 answers

1 accepted

0 votes
Answer accepted

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

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.

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.

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

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you