# Best way to filter on boolean data

**URL:** <https://forum.adalo.com/t/best-way-to-filter-on-boolean-data/21804>\
**Category:** Get Help\
**Created:** [January 9, 2022, 2:15pm UTC](https://forum.adalo.com/t/best-way-to-filter-on-boolean-data/21804 "2022-01-09T14:15:40Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![milincheta](https://avatars.discourse-cdn.com/v4/letter/m/8dc957/32.png) [@milincheta](https://forum.adalo.com/u/milincheta)\
**Post date:** [January 9, 2022, 2:15pm UTC](https://forum.adalo.com/t/best-way-to-filter-on-boolean-data/21804/1 "2022-01-09T14:15:40Z")

</div>

Hi,  
I have a list of Orders, some of them are paid some not, lets say.  
The **Paid** field is a boolean on the **Orders** table. As admin I can see a list of orders, but I am trying to implement a filter, like a toggle, to see only those Paid or all.  
What would be the best way to achieve it?  
Thanks!

---

<div class="post-metadata">

**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\
**Post date:** [January 9, 2022, 2:20pm UTC](https://forum.adalo.com/t/best-way-to-filter-on-boolean-data/21804/2 "2022-01-09T14:20:55Z")

</div>

Hi @milincheta👋

You can add a list and connect it to the Orders Table and set a filter Paid true/false property is true.

And you can add another list to show all orders.

Thank you

---

<div class="post-metadata">

**Author:** ![TKOTC](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/tkotc/32/6863_2.png) [@TKOTC](https://forum.adalo.com/u/TKOTC)\
**Post date:** [January 9, 2022, 4:12pm UTC](https://forum.adalo.com/t/best-way-to-filter-on-boolean-data/21804/3 "2022-01-09T16:12:55Z")

</div>

Sadly, boolean values are the most used type in development, but they are poorly supported in Adalo. Like Dilon said, you can make 2 lists and set them to sometimes visible if one is true or not. The alternative is to not use boolean database types, but text database types and only put in Y or N, or yes/no in the field rather than boolean, then you can have a work around where the **Paid** filter on the list is **not** equal to the magic text of an input field remove the border and background color and make it 0x0 in size, then you have 2 buttons labelled `Paid` or `All`, clicking on the paid button will set the input field value to ‘N’ or empty, so paid will filter where paid is not equal to N (which is Y), and all will filter where paid is not equal to empty (which is all recorders, if implemented correctly)

---

<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:** [January 19, 2022, 4:13pm UTC](https://forum.adalo.com/t/best-way-to-filter-on-boolean-data/21804/4 "2022-01-19T16:13:37Z")

</div>

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