How to exclude deleted option sets value from result?

yuehong · 2024-11-07T09:23:20.044Z

I have a database structured as follows:

Permission

Page: page (option sets)
Permission: permission (option sets)

When performing a “Search for Permission”, how can I exclude results where the page refers to a deleted option set value?

cmarchan · 2024-11-07T09:32:56.057Z

search :filtered :advanced :this dataType’s option set display is not empty

yuehong · 2024-11-07T09:56:54.530Z

Thank you for your answer. But I am lost.

Screenshot 2024-11-07 at 17-54-26 Yuehong Bubble Editor362×225 2.46 KB

Screenshot 2024-11-07 at 17-52-34 Yuehong Bubble Editor363×173 2.86 KB

I could not find “display is not empty” option. Please let me know where I did wrong.

cmarchan · 2024-11-07T09:58:13.453Z

Explore how advanced filtering works in Bubble

yuehong · 2024-11-07T10:09:10.024Z

Thank you for sharing the video tutorial. This is what I have done:

Screenshot 2024-11-07 at 18-06-33 Yuehong Bubble Editor654×275 7.63 KB

But it still showing the result with the deleted option set value.

cmarchan · 2024-11-07T10:12:30.799Z

What part of the options set is deleted?

If you deleted a display … then change that last part of the expression to say “is not” and then use :arbitrary text to add character by character the label that you deleted

boston85719 · 2024-11-07T12:09:18.431Z

Use the optimize app feature as that is only way to truly remove deleted options

yuehong · 2024-11-08T01:17:58.406Z

boston85719:

Use the optimize app feature

May I know what are the optimized app feature to be used?

cmarchan · 2024-11-08T02:48:53.381Z

Settings / General / App File Management / Optimize Application Button

Review the documentation prior to running this process so that you can understand its reach.