I need jira backlog count, how do I get this? Please suggest.
Hi @dhandapani
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Which table i have to search for the backlog details?
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
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
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.
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.
Still have a question?
Get fast answers from people who know.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.