Help with do a search for:filtering many to many using a custom state list based on an option set list

[boston85719]

I’ve never used the intersect method and not sure if it would return different results than the method I use.

I also don’t use custom states in most cases and opt to use URL parameters, so that the user can navigate using browser navigation and not lose their search…this also allows them to save the URL to the DB as a single text field if they want to save a search.

How to set Parameter as a List

Update to this Tip If you are using an approach to displaying your results that incorporates a reusable element, you would not be able to use this method…and in fact this method may be able to be adjusted using the following approach and avoids the multiple custom states for ‘is in’ vs ‘is not in’ You can do this without using any custom states [Screen Shot 2020-12-10 at 3.12.07 PM] Essentially the extract with regex pattern takes the parameter and turns it into a text list so that the cont…

Here are some screen shots from an application I use during a lesson on Data Modeling in Bootcamps I run.

Notice in the Restaurant Data type some fields are lists of options while others like Brooklyn Neighborhood is a single option.

Then on the element holding the search results this is the setup for the search using the filters

And here is an example of a search result using only two filters for cuisine type

In that screen shot only 2 restaurants search both American and Seafood, although there is a 3rd restaurant that serves American, however, it doesn’t serve Seafood so it is omitted from the results.

I believe this may be the difference between using intersect with VS the method I employ, however, I am not familiar with the intersect method and how it returns results.

And a final screen shot below of using three filters on cuisine type