How do I build the url of an issue from JIRA database

Question

I need to either extract or build the full URL of an issue so I can add an hyperlink to it from a report.

My JIRA database is on a SQL Server. I know the base url and how to find it but I can't figure out how the rest of it is build, other than the obvious jira key.

JimmyVanAU · Answer

Ah, that's a link to a version, not an issue.

That is in the database (not built at runtime).

You might find this link helpful https://developer.atlassian.com/server/jira/platform/database-schema/

Are you planning to link to the version for release note purposes?

maps apps · Answer

I thought about this but some are like this:

https://jira.ca.objectiflune.com/projects/ITAPPS/versions/43701

Now is the info to build it found somewhere in the database or is it build by JIRA at run time?

JimmyVanAU · Answer

Hi,

Welcome to the community.

To construct the URL should be pretty simple with a concatenate.

https://jira.acme.com/browse/TC-52893 is a typical URL,

so you can concat:

http[s]://{base_URL}/browse/{issue_key}

Hope that helps :)