how do i search for tickets that are ready for Production but have not been released?

[Bridgette Dennis]

Im looking for help to find a query that will work for tickets that are ready for prod or development done but have not been moved to completed status ? 

[Nic Brough -Adaptavist-]

It will probably be something like

status = "ready for prod" and fixversion in unreleasedversions()

[Bridgette Dennis]

thanks what worked was "Status = "ready for  prod" and fixversion is EMPTY 

[Nic Brough -Adaptavist-]

Ah, good, I wasn't too far off!  Thanks for letting us know!

[padraik]

are "ready for prod" and "development done" separate statuses, with "Completed" being another status?

If so, and you only want certain statuses, you can use a JQL query such as:

status in ("ready for prod", "development done")

If you want tickets in every status other than "Completed", you can use:

status != "Completed"

[Bridgette Dennis]

thank you. I have found that some tickets have "ready for prod and development done in the backlog , maybe they were moved there because they arent currently being worked but they are on hold because of a company code freeze. Once the code freeze lifts the plan is to move to production.  Is there a query to search for only tickets not completed in backlog status? 

[Nic Brough -Adaptavist-]

Everything in a backlog is, by definition, not completed.

I think we need you to tell us the actual question you want to ask of the search.  What are the characteristics of the issues that you are looking for? 

It's probably as simple as "status" as Padraik suggests, but we can't tell you that because we don't know what you are putting into Jira that you want to search.

[padraik]

I agree with Nic, the more details you can give, the easier it is to help.

• Can you confirm that "ready for prod" and "development done" are statuses?
• When you say "some tickets have 'ready for prod' and 'development done' in the backlog - do you mean the "backlog" view on a scrum/kanban board?
• Could you provide a screenshot of these tickets appearing in the backlog?

[Bridgette Dennis]

Hi Nic, I was able to find most of the issues , but yes the team I just joined I found tickets that are in a "ready for prod" status but are in the backlog .  I wanted to find a query that will pull up all tickets that are ready for prod as the status but havent been closed out .

[padraik]

by "closed out", you may be meaning "resolved"

status = "ready for prod" and resolution IS EMPTY

would get you your result if that's the case

[Bridgette Dennis]

thank you !