JQL query help

[Stefannie Tan]

Hi, I want to create a simple jql query for the following scenario:

I want to insert a "for prod release" column in our sprint board. I am aware that in order to achieve this, i need to create the corresponding status. i did and set it to resolution of "done" (because it's a step after our definition of done). i'm aware that by doing this, they will disappear once i end the current sprint.

so i want to set up a simple jql query to use as a filter for the sprint board. essentially, i want to be able to view the "for prod release" tickets along with the current active sprint tickets.

my first impulse is just to do a query for tickets with "prod release" status, but that will exclude the current sprint tickets.

thanks for any advice you can give.

[Iryna Komarnitska_SaaSJet_]

Hello @Stefannie Tan ,

If you have difficulty understanding JQL queries, I can recommend the Text to JQL gadget that my team recently released. This AI/ML-based solution takes natural language text entered by the user and translates it into an equivalent JQL query.

It's free!

I hope it will help you!

[Rilwan Ahmed]

Hi @Stefannie Tan ,

The Active sprint board will only display tickets which are part of it. You can just create a quick filter and add JQL  status = "for prod release" to it. It will display only tickets which are part of open sprint and in status "for prod release".

https://support.atlassian.com/jira-software-cloud/docs/configure-quick-filters/ 

[Stefannie Tan]

@Rilwan Ahmedhi, thank you! i tried it, but it only showed me tickets with that status, and excluded the others. (screenshot below)

without filter:

after filter:

[Rilwan Ahmed]

Hi @Stefannie Tan ,

Click Clear all and it will display all tickets irrespective of quick filters created. 

[Marta Woźniak-Semeniuk]

Hey @Stefannie Tan 

Using Advanced search features you can type the following:

 project = MyProjec AND sprint in openSprints ()

to retrieve a list of issues under your current Sprint of project 'MyProject'