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]

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