The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
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
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?
👋 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...
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.