# External Collection filter is not working

**URL:** <https://forum.adalo.com/t/external-collection-filter-is-not-working/5846>\
**Category:** Get Help\
**Created:** [November 11, 2020, 8:55am UTC](https://forum.adalo.com/t/external-collection-filter-is-not-working/5846 "2020-11-11T08:55:58Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![ArijitDas](https://avatars.discourse-cdn.com/v4/letter/a/22d042/32.png) [@ArijitDas](https://forum.adalo.com/u/ArijitDas)\
**Post date:** [November 11, 2020, 8:55am UTC](https://forum.adalo.com/t/external-collection-filter-is-not-working/5846/1 "2020-11-11T08:55:58Z")

</div>

Hi,  
I am not able to use filters on external collection list. I have an external collection called Organizations which contains fields like name,id and logoUrl and it contains 3 records. However when am trying to filter the collection by name , it is not restricting the data and instead shows all the data.The filter I am using is ({name} = ‘Admin’)  
Please can someone help. I have followed the link to set this up but its not working.  
[Filtering Airtable Lists - Adalo Resources](https://help.adalo.com/integrations/external-collections-with-apis/airtable/working-with-lists/filtering-airtable-lists).

 ![filter](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/7/7ef8527f703e69c7348d528c92944d51f79d8435.png) ![org](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/0/0b828299506499bb8c59575c752013037f6929b2.png)

---

<div class="post-metadata">

**Author:** ![ArijitDas](https://avatars.discourse-cdn.com/v4/letter/a/22d042/32.png) [@ArijitDas](https://forum.adalo.com/u/ArijitDas)\
**Post date:** [November 11, 2020, 12:36pm UTC](https://forum.adalo.com/t/external-collection-filter-is-not-working/5846/2 "2020-11-11T12:36:18Z")

</div>

Can someone help here please !!

---

<div class="post-metadata">

**Author:** ![bhanu](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/bhanu/32/6859_2.png) [@bhanu](https://forum.adalo.com/u/bhanu)\
**Post date:** [November 11, 2020, 3:27pm UTC](https://forum.adalo.com/t/external-collection-filter-is-not-working/5846/3 "2020-11-11T15:27:17Z")

</div>

Try removing the brackets and curly brackets and do this. It works for me.

name=‘Admin’

---

<div class="post-metadata">

**Author:** ![ArijitDas](https://avatars.discourse-cdn.com/v4/letter/a/22d042/32.png) [@ArijitDas](https://forum.adalo.com/u/ArijitDas)\
**Post date:** [November 11, 2020, 3:31pm UTC](https://forum.adalo.com/t/external-collection-filter-is-not-working/5846/4 "2020-11-11T15:31:33Z")

</div>

No it doesnot work for me. I have tried that before. I think it is API dependent. I am not using Airtable. I am connecting to graphql API

---

<div class="post-metadata">

**Author:** ![pford](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/pford/32/4648_2.png) [@pford](https://forum.adalo.com/u/pford)\
**Post date:** [November 11, 2020, 3:37pm UTC](https://forum.adalo.com/t/external-collection-filter-is-not-working/5846/5 "2020-11-11T15:37:08Z")

</div>

Unless graphQL has a parameter called filterByFormula, this query won’t work. The filterByFormula param is specific to Airtable.

---

<div class="post-metadata">

**Author:** ![ArijitDas](https://avatars.discourse-cdn.com/v4/letter/a/22d042/32.png) [@ArijitDas](https://forum.adalo.com/u/ArijitDas)\
**Post date:** [November 11, 2020, 3:57pm UTC](https://forum.adalo.com/t/external-collection-filter-is-not-working/5846/6 "2020-11-11T15:57:48Z")

</div>

I have a filter parameter called search in one of my graphql collection but how do i query it? Is there a documentation around it?

---

<div class="post-metadata">

**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:** [November 21, 2020, 3:57pm UTC](https://forum.adalo.com/t/external-collection-filter-is-not-working/5846/7 "2020-11-21T15:57:50Z")

</div>

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.
