How do I create a filter for due dates within 2 weeks?

Laura Thorsvik

Wondering if you could help me learn how to create a filter to identify items that have a deadline two weeks away (in the future). While we routinely track items that have passed their due date, I'd like to start tracking in advance of the due date so I can provide friendly reminders to my team to address items with due dates coming in the near future and avoid missed deadlines.

Specifically, I'd like to create a filter with the following requirements:

• Specific Project
• Specific item (i.e., training gaps)
• Status is not Closed
• Only include those assigned to team members that roll up to me
• If Gap Training Due Date is within 2 weeks 

Thank you for your guidance!

Laurie Sciutti

Hi @Laura Thorsvik ~ not sure how you're tracking training gaps and team members but this JQL should get you started:  

 

project = XXXX and statusCategory != Done and duedate <= 14d

 

For training gaps. if you're using a specific issue type (or Component or Label), include that with an "AND" statement in your JQL.  As for team members, you can use "assignee = user1, user2, etc" or better yet, if you are using groups, you can "assignee in membersOf("group name")".

 

HTH.