# Table field not in collection, no filter available

**URL:** <https://community.weweb.io/t/table-field-not-in-collection-no-filter-available/8637>\
**Category:** How do I?\
**Tags:** design, supabase\
**Created:** [May 17, 2024, 12:46pm UTC](https://community.weweb.io/t/table-field-not-in-collection-no-filter-available/8637 "2024-05-17T12:46:23Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![BertrandG](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/bertrandg/32/5129_2.png) [@BertrandG](https://community.weweb.io/u/BertrandG)\
**Post date:** [May 17, 2024, 12:46pm UTC](https://community.weweb.io/t/table-field-not-in-collection-no-filter-available/8637/1 "2024-05-17T12:46:23Z")

</div>

I want to find out in a workflow with a Select command (Supabase) **how many records do not contain a delivery date** :

![image](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/5/5f27fd2c0d97b65786de796d337d6baefbda2bc7.png)

I’m filtering the SELECT by 2 conditions: 1. task\_id and 2. delivery date. Here is just one example for a Condition for the delivery date (I also tried others):

![image](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/e/ec784598326c2a9ca0e9897262d0b1dd4e99b519.png)  
The formula for is less than was **Date (“2020-01-01”**) since all dates will be after that date.  
I also tried **Column equals null** but this doesn’t work either since the field isn’t included in the collection.

There is **ONE** job w/o a delivery date but WeWeb says **0**.

![image](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/5/56b9a8a0a5050bb481d69ae0d43d9a337d3c8e21.png)

That doesn’t work. In the data record, the delivery date value is **null**. The reason for this issue is probably this: When I retrieve the collection under Data, the Delivery Date field is not included in the result unless it contains a value:

Job 37 **with** a delivery date:  
 ![image](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/b/b18181f5495075411a2018fc9ff791854a057d25.png)

Job 38 **w/o** delivery date:  
 ![image](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/8/848db1cf0956eb837aa662ee5bdde838cf9454a7.png)

But there is **no filter** for this case. Can I still determine how many records do not have a delivery date?

---

<div class="post-metadata">

**Author:** ![Mael](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/mael/32/13246_2.png) [@Mael](https://community.weweb.io/u/Mael)\
**Post date:** [May 21, 2024, 4:27pm UTC](https://community.weweb.io/t/table-field-not-in-collection-no-filter-available/8637/2 "2024-05-21T16:27:04Z")

</div>

Hello,

I am not sure to get exactly what you want to do. If you want to get the item without any date value, you need to set a filter “column is equal to a value” with the value `""` or `null` depending on your database

 ![Screenshot 2024-05-21 at 18.25.14](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/5/5728b758674401a0784a61939a1622a37593a53f.png)

---

<div class="post-metadata">

**Author:** ![BertrandG](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/bertrandg/32/5129_2.png) [@BertrandG](https://community.weweb.io/u/BertrandG)\
**Post date:** [May 22, 2024, 3:25pm UTC](https://community.weweb.io/t/table-field-not-in-collection-no-filter-available/8637/3 "2024-05-22T15:25:06Z")

</div>

HiMael,  
I also tried this but WeWeb throws an error. I guess it’s a **bug**. As I explained before, if a table field is empty in Supabase, WeWeb does not include the field in the retrieved collection record. And then I can’t use a formula which needs this field.  
Have a look at the two **screenshots** above, showing a record **with** and **without** a delivery date.