Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
Level
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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

Current Linkage Displayed in GUI

On the GUI, when a link is removed it no longer shows on the screen when you are looking at the main screens. 

We have looked over the linking table, but could not discern how to tell what the current linkage is vs the entire history. We only care about the current linking of the issue.

1 answer

Hi @Brian Kimmel I'm not sure what you mean. When you care only about current links, why do you need to check linking table.

But if you are just concerned and need to know where the history items are stored, I can confirm it is stored in different tables so is you can't see link in DB table when it is removed, it should be ok.

Name of the table which stores history should be "changeitem".

When someone inadvertently links a story to the wrong epic and then fixes it, when you look through the GUI at the linkage, you will not see the linkage to the epic that was done in error.

My team creates reporting based on linkage, however the  issuelink table and others seems to maintain history. So when querying, I wish to know how to only grab the current links like the GUI displays...it seems there should be some date related components that would allow for this.

Hi @Brian Kimmel still do not undestand, sorry ;)... 

  1. someone creates wrong link
  2. someone fixes wrong link to correct  link
  3. correct link is displayed in GUI
  4. issue can be queried by correct link

The only problem I can see is that

  • invalid link is still displayed in the history of the issue

Is it the problem?

OR

You just need to prepare report with current Jira data? If it is the case, it would be helpful if you share what type of Jira you uses (Cloud, Server/DataCenter). You can see some information in Issue filter or you can user Jira API (Java for server or REST API for Cloud)

We have reporting that we do out of the databases behind the GUI. The old/incorrect linkage still resides in the linkage tables even though the GUI does not display it. I wish to understand how the GUI knows what the current linkage is and what tables are being used to determine it so that our back end reporting is ONLY showing current valid links.

OK @Brian Kimmel I understand now. There is a table called issuelink which holds information about links between issues.

But it only stores active links (I just tested it). So it would be better to check your "reporting". Do you have more information about your reporting? What DB tables are used in it? Can you provide SQL query etc.?

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Service Management

ThinkTilt is joining the Atlassian Family!

This morning, Atlassian announced the acquisition of ThinkTilt , the maker of ProForma, a no-code/low code form builder with 700+ customers worldwide. ThinkTilt helps IT empower any team in their or...

308 views 18 19
Read article

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