# Boolean expression on 1, 0, true , false

**URL:** <https://community.dremio.com/t/boolean-expression-on-1-0-true-false/11303>\
**Category:** Uncategorized\
**Created:** [December 21, 2023, 9:57pm UTC](https://community.dremio.com/t/boolean-expression-on-1-0-true-false/11303 "2023-12-21T21:57:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![crazyisjen](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/crazyisjen/32/4552_2.png) [@crazyisjen](https://community.dremio.com/u/crazyisjen)\
**Post date:** [December 21, 2023, 9:57pm UTC](https://community.dremio.com/t/boolean-expression-on-1-0-true-false/11303/1 "2023-12-21T21:57:04Z")

</div>

Hi everyone  
current dremio version: v.19

when filter by boolean field for vds , not possible to use filter value of 1,0 but only can use true , false  
such as: WHERE {column} =1 (return nothing even there is valid case hit the true condition)  
is there some bug? how to fix it? thx

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [December 27, 2023, 5:04am UTC](https://community.dremio.com/t/boolean-expression-on-1-0-true-false/11303/2 "2023-12-27T05:04:03Z")

</div>

@crazyisjen Please send the job profile. Wondering if the FILTER is been treated as INTEGER,