Filtering Lists Without Flush Cached Joins or "Portal Filtering"
I'm trying to tackle filtering (list layouts and portals) without the use of using the built in portal filter option.
I have read and heard that using the Refresh Window [Flush Cached Join Results] can really slow down a file with large amounts of records, and I want to avoid using it.
I have created a sample setup with a Projects Table and a Parts Table. The idea is that I want to create a list for the user to search to find a part to add to a project.
I want the user to be able to filter by category, type, and then a text filter (which will show any parts *containing* the text in the box).
I understand how to create the relationships that link category and type to the list. I still have two challenges:
1) if the user leaves the category field blank, how do I show all parts with all categories?
2) How do I do a filter where the part number *contains* what is in the search box?
My objectives would be to minimize the amount of globals in all tables, and as mentioned before, avoid using the built in portal filter technique.
See attached screenprints.