Current Linkage Displayed in GUI

Question

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.

Martin Bayer _MoroSystems_ s_r_o__ · Answer

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.?

Brian Kimmel_ektzij · Answer

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.

Martin Bayer _MoroSystems_ s_r_o__ · Answer

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

* someone creates wrong link
* someone fixes wrong link to correct  link
* correct link is displayed in GUI
* 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)