Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,293,412
Community Members
 
Community Events
165
Community Groups

Some issue links do not appear in the issuelink database table

Edited

Hi everybody,

we use Jira DC 8.20.3 and have an issue type "Paket" (package) above Epics in our Plans hierarchy. So we can link Packages and Epics via the custom field "Parent Link".

Now we have to remove such links for a certain project which only contains packages.
So I wanted to do a database selection on the database table issuelink to find out which packages are linked to which Epics. I've found out that some of these links are stored in the table issuelink and some are not.

My SQL was:


SELECT ps.pkey, jis.issuenum, ts.pname, pd.pkey, jid.issuenum, td.pname, lt.*
FROM jiraissue jis, jiraissue jid, issuelink l, project ps, project pd, issuelinktype lt, issuetype ts, issuetype td
WHERE jis.project = ps.id
AND jid.project = pd.id
AND jis.issuetype = ts.ID
AND jid.issuetype = td.id
AND l.SOURCE = jis.id
AND l.DESTINATION = jid.id
AND l.LINKTYPE = lt.ID
AND (ps.pkey = 'MPM' OR pd.pkey = 'MPM')

In Jira I can see Epics which show Parent Links to the project with the shortcut "MPM" which are NOT in the result of this query (though I see many other such links in the result).

Does anybody have an idea where the links are stored if they aren't in the issuelink table?

By the way: We also use "Xray for Jira" and this JQL also delivers Epics which do NOT appear when I use the SQL:
"Parent Link" in ProjectParentRequirements("MPM")

Many thanks and best regards
Gisela

1 answer

0 votes

Yeah, stop reading the database, it isn't in the shape you are guessing it is.  It's the worst way you can possibly report on Jira.

What problem are you trying to solve with this query?  What are you actually looking for and why?

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
Community showcase
Published in Jira Software

Upcoming changes to epic fields in company-managed projects

👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...

14,103 views 34 44
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