A user should be able to build filters and save them to access later.
There should be an interface where you can add multiple assigned_to values (users and teams) as well as do things like specify relative due date ranges (like today + 3 days), certain priority types, certain statuses.
Assigned_to should be an auto suggest that lets you add as many values as you want, which creates a number of OR clauses in the query. Status and Priority could be checkboxes which create OR clauses also.
You should be able to connect each group with a keyword like AND, OR, or NOT.
A user should be able to build filters and save them to access later. There should be an interface where you can add multiple assigned_to values (users and teams) as well as do things like specify relative due date ranges (like today + 3 days), certain priority types, certain statuses.
Assigned_to should be an auto suggest that lets you add as many values as you want, which creates a number of OR clauses in the query. Status and Priority could be checkboxes which create OR clauses also.
You should be able to connect each group with a keyword like AND, OR, or NOT.