# Query Column ignoring filter

**URL:** <https://community.glideapps.com/t/query-column-ignoring-filter/83823>\
**Category:** Report a Bug\
**Created:** [August 14, 2025, 2:11am UTC](https://community.glideapps.com/t/query-column-ignoring-filter/83823 "2025-08-14T02:11:57Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [August 14, 2025, 2:11am UTC](https://community.glideapps.com/t/query-column-ignoring-filter/83823/1 "2025-08-14T02:11:57Z")

</div>

Head scratcher: Query column with a filter –\> where (column) is empty. The Query column still returns a record even when the queried filtered column is not empty…anyone able to tell me why?  
https://www.loom.com/embed/51a8047d5ebd44cc98a4fb8905f9963c

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [August 14, 2025, 2:18am UTC](https://community.glideapps.com/t/query-column-ignoring-filter/83823/2 "2025-08-14T02:18:29Z")

</div>

Pretty sure it’s the lookup of the date. If I switch it to boolean, it works as expected…still a bug!

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 14, 2025, 11:26am UTC](https://community.glideapps.com/t/query-column-ignoring-filter/83823/3 "2025-08-14T11:26:52Z")

</div>

Seems you can sometimes get unexpected behaviour when Big Tables and Date values are combined. I’ve gotten into the habit of using two columns for dates in Big Tables. One that stores the actual date value, and another number type column that stores an integer representation of the date. And then I’ll use that for queries, filters, etc.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [August 15, 2025, 10:53am UTC](https://community.glideapps.com/t/query-column-ignoring-filter/83823/4 "2025-08-15T10:53:09Z")

</div>

Yeah…but what’s strange is that I’m just checking to see if the date is/is not empty…it has nothing to do with the value itself.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [February 11, 2026, 10:53am UTC](https://community.glideapps.com/t/query-column-ignoring-filter/83823/5 "2026-02-11T10:53:29Z")

</div>

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