How to get count of issues for each projects??

[Raju Anumula]

Hi Team,

In my instance, many projects are having single digit issues. how can I get a count of issues for each project?

Is it possible to get a list of project and count of issues through the database(Postgres)?

Thanks in advance.

[Tansu Akdeniz · Accepted solution]

Hi @Raju Anumula,

select count(*), p.pname from jiraissue i, project p where i.project = p.id group by p.pname, i.project;

[Raju Anumula]

Thanks a lot, @Tansu Akdeniz.

it's working fine, how we can get project creation date with count and name.

[Nic Brough -Adaptavist-]

You don't.  Project creation date is not recorded.

The project table has the name and the last issue number used, which is probably useful enough (it becomes inaccurate if people have moved or deleted issues in the project)

[Raju Anumula]

Hi @Nic Brough -Adaptavist-,

It is possible to get the first issue created date in the projects??

Thanks in advance.