Filter Database by Creator

Need help Database
1

I can’t seem to figure out something that I expect is quite simple. I’ve searched the Bubble docs and this forum but don’t see the same question.

I am viewing my database with the editor and I just want to filter a datatype by the Created by field. Searches work for other fields, but don’t seem to work when searching by an email address.

How do I find the records for a specific account in the database editor?

Thanks.

2

What do you mean when you say it doesn’t work?.. it’s not showing the correct items? Or not showing any items at all? Or what?

1 Like
3

Thanks for your reply. Sorry I was not more clear.

What I mean is I type in the email address for a user where I can see records of that data type. But the result is empty. I suspect there is a different way to filter by user for a data type.

For example, if I have a data type Lists and user1’s email address is user@email.com, then how do I find all records for Lists where the Created by field is user@email.com? If I search user@email.com in the search box, the result is empty, even though I can see the records on the screen when unfiltered.

4

Ah, I see… yeah the search bar on the data tab isn’t very useful…

Instead, you need to create a new ‘view’ - then you can apply whatever filtering you need.

1 Like
5

Oh wow. Thank you. I have created other views before but didn’t see that I can add a search constraint to it. What an odd UI. So I guess I have to modify that view’s search constraint each time I want to look at it differently.

Thanks.

6

Yep… that’s what database views are for…

1 Like