Before we start
Before we start, we will need some data. We’ve prepared the following tasks to show you how this works:
There is a belongs to relation between the tasks data model and web user data model.
This means a task can be assigned to only one web user. The other way around, a web user can have multiple tasks assigned to him/her.
Use the data list from the previous case
We currently show a list of web users and their tasks which have the status
Let’s say we also want to show the tasks that have the status
At the time of writing this document, we can not do a
in filter, else you might want to filter on Tasks.status in 'Todo, In progress'.
So we have to come up with another plan!
Fortunately, we have filter groups.
Let’s go to our current filter, which looks like this:
Now, we remove the row with the task status. We will add that one to a new filter group. Click on the row and press the delete (garbage) button:
After removal we get:
Now we press
We create our filter row with the status check on
And then press
Add rule to create another filter row for checking against the status
By default a group operator is
AND. Also in between the filter rows, this operator is copied. But because we can only have one status per task, this filter won’t work. We can’t have 1 task that has both statuses
In progress, so we will change the AND/OR to OR for the second group by pressing the OR on the right on top of the group:
Save and then press play. Your data list should look like this:
➝ Next article: Showing a list of your own tasks