JQL query help

Question

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.

Rilwan Ahmed · Answer

Hi @Stefannie Tan ,

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

Iryna Komarnitska_SaaSJet_ · Answer

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!

Stefannie Tan · Answer

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