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!

[Bill Sheboy · Accepted solution]

Hi @Laura Thorsvik -- Welcome to the Atlassian Community!

Adding to the other answers provided, Atlassian provides some free online training for using JQL to answer questions like yours.  Please look here for more information:

https://university.atlassian.com/student/path/849533-gain-project-insights-through-jql

Kind regards,
Bill

[Laurie Sciutti · Accepted solution]

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.

[Trudy Claspill]

Note this syntax is incorrect:

"assignee = user1, user2, etc"

The correct syntax is:

assignee in (user1, user2, user3)

[Trudy Claspill]

@Laura Thorsvik 

Adding on....

You can find more information about constructing search filters here:

https://support.atlassian.com/jira-software-cloud/docs/search-for-issues-in-jira/

If you are new to Jira you may find using the Basic Search view is the most helpful initially. It presents some of the fields that are commonly used in search and lets you select what you want those values to be. To find other fields to include in your search, click the + More button