Database query to get EPIC related to each worklog entry

Edward Frau

Hi everyone,

Currently I have a custom DB query that for each worklog entry retrieves some info such as Author, Status, Creation Date, Time Spent, Project Key, Issue Number, etc.

Now I need to add one more field which would be the EPIC linked to each worklog entry (whenever there is one), and this should appear in the form "<PROJECTKEY>-<ISSUENUMBER>". I can't figure out the query to achieve this result.

Any help would be highly appreciated, thank you.

David Leal_28ge8x

Is it a Jira Query Language question or something different. Please provide more details and context about your question.