SelectFilter: Filter by value, null or any
I have a Table with articles where you can filter by author (user_id). However, the user_id can also be null. This indicates that an article has been written by the whole team instead of a specific team member.
Is it possible to cover this with a SelectFilter? I can load the options by relation (check), the dropdown will also contains an "All" option that deactivates the filter (check), but I cannot find a way to add an additional dedicated null option with a label like "From the Team" that would add a ->whereNull('user_id') to the query?
Is it possible to cover this with a SelectFilter? I can load the options by relation (check), the dropdown will also contains an "All" option that deactivates the filter (check), but I cannot find a way to add an additional dedicated null option with a label like "From the Team" that would add a ->whereNull('user_id') to the query?
