I need jira backlog count, how do i get this. Please suggest.

[dhandapani]

I need jira backlog count, how do I get this? Please suggest.

[Alex Koxaras _Relational_ · Accepted solution]

Hi @dhandapani 

• Use the advanced issue search to search for all issues in the backlog
• Add a Count gadget on a dashboard using the above filter

[dhandapani]

Which table i have to search for the backlog details?

[Alex Koxaras _Relational_]

Why you need to search for a table? Are you on jira server?

You can make a JQL query like:

project = YOURPROJECT and status = backlog

[dhandapani]

yes I am using Jira database. From there i have to find the backlog record count

[Alex Koxaras _Relational_]

Try jiraissue table

[dhandapani]

Ok Sure I will check Jiraissue table. 

Can you share which column i have to check for this? because I don't find the corresponding column

[Alex Koxaras _Relational_]

Try ISSUESTATUS 

[dhandapani]

Thank you, it has numeric value like following (10001,10002,10000).

Still I have to check any other table to get the corresponding string value for this?

It will be helpful for me.

Thank you for your time.

[Alex Koxaras _Relational_]

Have a look at this https://developer.atlassian.com/server/jira/platform/database-schema/ and click on the database schema to find the suitable table and column :)

[dhandapani]

Thank you. Got it.