How to Exclude 'Yes' in a Search Filter?

itsdoleey · 2024-08-29T14:05:16.734Z

I’m using “Do a search for” in Bubble to return a list of chapters. I want to filter the results to include chapters where RestrictedChapter? is either “no” or empty. However, I can’t use != "yes" since that expression doesn’t exist in Bubble. How can I create this filter expression to achieve the desired result?

Even the advanced filtering for “is not” yes (seen below), doesn’t work.

georgecollier · 2024-08-29T14:09:26.569Z

There are only two states on yes/no (boolean) fields. Yes, or no. There is no empty.

When you create a new thing, or change a thing, if you set a yes/no field to empty, for all intents and purposes, you’re setting it to no.

You could create an Option Set with Yes/No/Empty and have RestrictedChapter? as an option set field.

Alternatively, you could have another field called RestrictedSet? which says whether the user has confirmed whether or not it’s a restricted chapter (whether
that be yes or no). Then, only include results where RestrictedSet? is yes and RestrictedChapter? is yes.

It’s a UX point I think Bubble should change, as, for example, these two settings are completely identical:

CleanShot 2024-08-29 at 15.09.46@2x1172×78 3.41 KB

CleanShot 2024-08-29 at 15.10.05@2x1210×78 3.61 KB

itsdoleey · 2024-08-29T14:12:19.522Z

Can’t believe i didn’t just try out it out with no and was just thinking through it.

yes, it works, thanks.

georgecollier · 2024-08-29T14:12:45.297Z

I did exactly the same thing when I started out - it’s not obvious if you’re not technical!

system · 2024-11-07T14:05:37.314Z

This topic was automatically closed after 70 days. New replies are no longer allowed.