# Filtering is not working **URL:** \ **Category:** Get Help\ **Created:** [May 12, 2021, 9:08am UTC](https://forum.adalo.com/t/filtering-is-not-working/12489 "2021-05-12T09:08:57Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![Andile](https://avatars.discourse-cdn.com/v4/letter/a/eb9ed0/32.png) [@Andile](https://forum.adalo.com/u/Andile)\ **Post date:** [May 12, 2021, 9:08am UTC](https://forum.adalo.com/t/filtering-is-not-working/12489/1 "2021-05-12T09:08:57Z")
Hi Guys. I am having a problem with filtering. I have a list of users, some are businesses and others would be normal users who would be searching for businesses and other users. I have created the search page. On the filtering, I have stated that the business must contain the search, and user name must contain the search but it doe not show anything when I search. What could I be missing? ---
**Author:** ![Andile](https://avatars.discourse-cdn.com/v4/letter/a/eb9ed0/32.png) [@Andile](https://forum.adalo.com/u/Andile)\ **Post date:** [May 12, 2021, 9:11am UTC](https://forum.adalo.com/t/filtering-is-not-working/12489/2 "2021-05-12T09:11:32Z")
I have looked over and over at tutorials on YouTube that show how it should be done but I just can not figure out what it could be that I am missing. I want to attach pictures to show you what I have done but it does not allow me. ---
**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\ **Post date:** [May 12, 2021, 9:13am UTC](https://forum.adalo.com/t/filtering-is-not-working/12489/3 "2021-05-12T09:13:18Z")
Hi @Andile, It’s difficult to guess what you’ve set up incorrectly without any screenshots or video showing the setup and the problem. Have you read this section [Sorting and Filtering Lists - Adalo Resources](https://help.adalo.com/component-basics/connecting-lists-and-forms-to-a-database/applying-filters-to-lists) and this tutorial [How to Create a Search Bar - Adalo Resources](https://help.adalo.com/how-to/how-to-create-a-search-bar)? Best regards, Victor. ---
**Author:** ![Andile](https://avatars.discourse-cdn.com/v4/letter/a/eb9ed0/32.png) [@Andile](https://forum.adalo.com/u/Andile)\ **Post date:** [May 12, 2021, 9:15am UTC](https://forum.adalo.com/t/filtering-is-not-working/12489/4 "2021-05-12T09:15:55Z")
Yeah I wanted to share but I am experiencing a problem attaching. I will have a look at what you sent and see what the problem could be. Thank you Victor ---
**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\ **Post date:** [May 12, 2021, 9:20am UTC](https://forum.adalo.com/t/filtering-is-not-working/12489/5 "2021-05-12T09:20:27Z")
@Andile by the way, if you added 2 filters, something like (BusinessName - Contains - SearchInput) and (UserName - Contains - SearchInput), you won’t get results for search. Filters in lists work by “AND” condition, i.e. for the item to be displayed, _both_ conditions should be met. In your case, I’d recommend having a “Is Business” true/false property, add it as a first filter (=true), and add 2nd filter “Name” contains searchInput. Best, Victor. ---
**Author:** ![Andile](https://avatars.discourse-cdn.com/v4/letter/a/eb9ed0/32.png) [@Andile](https://forum.adalo.com/u/Andile)\ **Post date:** [May 12, 2021, 9:21am UTC](https://forum.adalo.com/t/filtering-is-not-working/12489/6 "2021-05-12T09:21:09Z")
So I have managed to attach the picture and as far as I can see it seems all is as it should be. ![Screenshot (180)](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/7/7510116abc3c45e5c99cbfc251784be1cdb2a337.png) ![Screenshot (181)](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/1/1988bec3725b2e1ff281ef736995e1a4ca866485.jpeg) ![Screenshot (182)](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/e/e622eae6881008be784b2c3768fe7aabef4a887f.png) ![Screenshot (183)](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/f/f854ca0fcc983e9179aaef8c20eb0008a50dae52.png) ![Screenshot (184)](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/f/f6a39825e10d2e707762e2267c29470a75485f59.png) ---
**Author:** ![Andile](https://avatars.discourse-cdn.com/v4/letter/a/eb9ed0/32.png) [@Andile](https://forum.adalo.com/u/Andile)\ **Post date:** [May 12, 2021, 9:23am UTC](https://forum.adalo.com/t/filtering-is-not-working/12489/7 "2021-05-12T09:23:17Z")
Well I did think this could be an issue so to test I removed all filters and just used one eg Username and it was doing the same thing. Let me try again just to double check. ---
**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\ **Post date:** [May 12, 2021, 9:25am UTC](https://forum.adalo.com/t/filtering-is-not-working/12489/8 "2021-05-12T09:25:34Z")
@Andile, So, your first screenshot shows that in order for the record to be shown, ALL conditions (Username, Businessname and some other) should be met. As I told before, filters work based on “AND” logic. Best, Victor ---
**Author:** ![Andile](https://avatars.discourse-cdn.com/v4/letter/a/eb9ed0/32.png) [@Andile](https://forum.adalo.com/u/Andile)\ **Post date:** [May 12, 2021, 9:27am UTC](https://forum.adalo.com/t/filtering-is-not-working/12489/9 "2021-05-12T09:27:14Z")
You are right. I just remove everything and it seems to be working. Now can you please send me a screenshot of what you mean by the “and” logic. ---
**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\ **Post date:** [May 12, 2021, 9:31am UTC](https://forum.adalo.com/t/filtering-is-not-working/12489/10 "2021-05-12T09:31:49Z")
@Andile “AND” logic means that for the item to be displayed, _both_ filter conditions should be met. So: if you have 2 filters, for example, (BusinessName - Contains - SearchInput), (UserName - Contains - SearchInput), and you enter “Pizza” into search input, you’ll get the the records ONLY if their UserName contains Pizza **AND** their BusinessName contains Pizza. Best, Victor ---
**Author:** ![Andile](https://avatars.discourse-cdn.com/v4/letter/a/eb9ed0/32.png) [@Andile](https://forum.adalo.com/u/Andile)\ **Post date:** [May 12, 2021, 9:36am UTC](https://forum.adalo.com/t/filtering-is-not-working/12489/11 "2021-05-12T09:36:24Z")
So how would I state it to only select the every business and user name that contain that does contain Pizza and exclude everything else. EG. I want it to search by name(business or personal), address, service or product etc. This is what is what is the proble. ---
**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\ **Post date:** [May 12, 2021, 9:40am UTC](https://forum.adalo.com/t/filtering-is-not-working/12489/12 "2021-05-12T09:40:08Z")
@Andile one of the ways is to create a separate “Search Index” property in the collection, where you put all the info you’d like to be “searchable”, and use this Search Index with “Contains” filter. Have a look at this video by @pford: [Creating Custom Searches and Search Bars in Adalo - YouTube](https://www.youtube.com/watch?v=ddf3dx-bIhs) Best, Victor. ---
**Author:** ![Andile](https://avatars.discourse-cdn.com/v4/letter/a/eb9ed0/32.png) [@Andile](https://forum.adalo.com/u/Andile)\ **Post date:** [May 12, 2021, 9:43am UTC](https://forum.adalo.com/t/filtering-is-not-working/12489/13 "2021-05-12T09:43:47Z")
Thank you so much. I will have a look at it right away. You have been a lot of help. ---
**Author:** ![Andile](https://avatars.discourse-cdn.com/v4/letter/a/eb9ed0/32.png) [@Andile](https://forum.adalo.com/u/Andile)\ **Post date:** [May 12, 2021, 9:57am UTC](https://forum.adalo.com/t/filtering-is-not-working/12489/14 "2021-05-12T09:57:25Z")
You have no idea how many times I have watched that tutorial. The problem is I did not know what I was looking for until you mentioned the “and” logic. You are a lifesaver because my entire app was depended on this small part. I had that blank screen created but did not use it properly. Thank you so much. ---
**Author:** ![Andile](https://avatars.discourse-cdn.com/v4/letter/a/eb9ed0/32.png) [@Andile](https://forum.adalo.com/u/Andile)\ **Post date:** [May 12, 2021, 6:51pm UTC](https://forum.adalo.com/t/filtering-is-not-working/12489/15 "2021-05-12T18:51:02Z")
I am still having an issue here. There users are created as logged in user therefor update as such. If I am using the solution on the tutorial you suggested I would need to update them as current user so I am not sure how I would do that. Can you please give a suggestion. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\ **Post date:** [May 22, 2021, 6:51pm UTC](https://forum.adalo.com/t/filtering-is-not-working/12489/16 "2021-05-22T18:51:40Z")
This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.