How to Exclude 'Yes' in a Search Filter?

image

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.

image

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:


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

yes, it works, thanks.

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

1 Like

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