Hi,
There are 1000's of projects created in our instance. We would like to retrieve last updated date of each of those projects to make crucial business decisions.
I used below PostgreSQL query to get the data.
SELECT DISTINCT p.pkey,p.LEAD,MAX(i.UPDATED) as "Last Updated"
FROM jiraissue i
INNER JOIN project p
ON p.ID = i.PROJECT
GROUP BY p.pkey,p.LEAD,p.pname
ORDER BY MAX(i.UPDATED) ASC
However, I still see discrepancies with certain projects. please advise how should I modify the query to retrieve last action date of these projects.
