Hello,
I'm encountering an issue in Jira where I cannot combine the "Due this week" filter with the assignee filter. When I select "Due this week" from the dropdown, the URL updates to:
?filter=duedate <= endOfWeek() and duedate >= startOfWeek()Subsequently, when I select an assignee from the dropdown, the URL changes to:
?filter=assignee = "{user-id}"However, the previous due date filter disappears, and the two filters don't seem to combine. Is this expected behavior, or am I missing something?
Hi Vassia,
What you’re seeing is expected behavior, the built-in filter dropdowns in Jira’s issue view or board only apply one filter at a time, so when you select “Due this week” and then choose an assignee, the previous filter is replaced. Unfortunately, these UI filters don’t combine dynamically.
How to achieve dynamic filtering
If you want to dynamically choose values (e.g., pick any assignee and keep the “Due this week” condition), you have two main options:
Option 1: Use JQL in the Issue Navigator
You can write a query like:
duedate >= startOfWeek() AND duedate <= endOfWeek() AND assignee = currentUser()
Or replace currentUser() with any username. This gives you full flexibility, but it’s manual.
Option 2: Use Quick Filters on Boards
Quick Filters combine with AND logic, so you can create:
When you click both, Jira applies both conditions.
Learn more: Configure Quick Filters.
Option 3: Dynamic Filters with Marketplace Apps
If you need true dynamic filtering with dropdowns (e.g., pick any assignee or date range on the fly), Jira doesn’t support this natively. You can use apps like:
References:
Hope this help!
welcome to the community!
If you're open to solutions from the Atlassian Marketplace, I think you might like the app that my team and I are working on: JXL for Jira.
JXL is a full-fledged spreadsheet/table view for your work items (issues) that allows viewing and inline-editing all your work item fields, much like you’d do in e.g. Excel, Google Sheets, Smartsheet, or Airtable. You can also dynamically sort and filter your work items using simple, Excel-style interactions, like e.g. so:
Every JXL sheet is powered by a JQL query or saved filter, so you have full control over the work items of your sheet (the so-called sheet scope). Column filtering is then applied on top of this sheet scope. You would probably want to set the sheet scope to
duedate <= endOfWeek() and duedate >= startOfWeek()
and then select the relevant assignee through column filtering.
I should also add that JXL can do much more than the above: From support for configurable issue hierarchies, to issue grouping by any issue field(s), sum-ups, or conditional formatting.
Any questions just let me know,
Best,
Hannes
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.