How to get the most recent comment of an issue in jira

Ashwini Ganesan

Please share the query to get the most recent comment of an issue id in jira

 

SELECT CONCAT(P.pkey,'-',JI.issuenum) as issuekey, JA.actionbody, JI.updated as 'update', JI.id
FROM jira_jiraaction JA
JOIN jira_jiraissue JI ON JA.issueid = JI.id
JOIN jira_project P ON JI.project = P.id
WHERE JA.actiontype = 'comment'

this returns all the comment but I the most recent comment for each id

Mohamed Benziane

Hi,

You could do something like this

SELECT CONCAT(P.pkey,'-',JI.issuenum) as issuekey, JA.actionbody, JI.updated as 'update', JI.id
FROM jira_jiraaction JA
JOIN jira_jiraissue JI ON JA.issueid = JI.id
JOIN jira_project P ON JI.project = P.id
WHERE JA.actiontype = 'comment'
ORDER BY JA.id DESC
LIMIT 1