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