Staying Organized with Jira JQL

Posted by Josh Ketchum

I don't know about you, but a lot of times, I wind up on more projects than one.   Whenever that happens, I like to list out the tasks I need to do according to the projects, and the order I want to do them in, and little "progress points" in my One Note before I got started for the day.   This helped me keep my own self on task and make sure I do not do the unthinkable and forget a task on "my own plate." 

Over time, I realized what I was doing could be easily automated and organized via the use of Confluence & Jira Filter Queries.   After all, everything I am working on should be a story, bug, or task in Jira, right?


The JQL Queries

What I did was create a JQL filter in Jira that can give me a report on what items are "on my plate" that need my attention.    

assignee = "" AND (status = "In Progress" OR status = "To Do" OR status = "Selected for Development" OR status = "Backlog" OR status = "Working") 
    OR project = "Project #1 that I code Review For" AND status = "Ready for Code Review" OR project = "Project #2 that I code Review For" AND status = "Ready for Code Review"
    ORDER BY updatedDate DESC

I also wrote a quick query to get the items in the last 7 days where I was mentioned somewhere in the ticket.  

(summary ~ "" OR description ~ "" OR comment ~ "") AND updatedDate >= -7d

The Results

The result is a simple list of Jira tickets, with the columns depending on your own settings of your widget or confluence macro.



Cookies help us improve your website experience.
By using our website, you agree to our use of cookies.