Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,368,846
Community Members
 
Community Events
168
Community Groups

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

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

1 answer

1 accepted

3 votes
Answer accepted
Alex Koxaras Community Leader Sep 13, 2022

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

Which table i have to search for the backlog details?

Alex Koxaras Community Leader Sep 13, 2022

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

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

Alex Koxaras Community Leader Sep 13, 2022

Try jiraissue table

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 Community Leader Sep 13, 2022

Try ISSUESTATUS 

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 Community Leader Sep 14, 2022

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 :)

Thank you. Got it. 

Like Alex Koxaras likes this

Suggest an answer

Log in or Sign up to answer