All tables are joined via Data Manager. Request Nr. 2 and Request Nr. 3 in the linking table doesn't have Request Type set, but it is known internally for our salesmen that all such requests should be considered Passenger requests.
I want to create a Filter Pane which would allow me to filter requests by request type. The Filter Pane itself is not an issue, but I cannot wrap my head around how to do filtering correctly for our supposed rule that all requests without types are Passenger requests. If I select "Cargo" it is filtering fine, but if I select "Passenger" I only get Request Nr. 4. I need to select rows 2, 3 and 4 somehow. Any ideas?