It is precisely for this reason that I’ve suggested a fourth View method:
In the absence of such a View, I see two alternatives:
- Do the filtering via Server Module functions, as noted above. This works best when returning relatively few rows, as they must all be returned at once (not a page at a time, as a real View can do).
- Split the table, as you’ve done.
Depending on how many different “views” are needed, this might need several splits, resulting in a very fragmented/duplicated group of tables to maintain. On the other hand, it allows paging, which can improve performance (user experience) for larger numbers of rows.
I hadn’t considered your approach in detail. Thank you for making me think!