# Use \`eq\` \[Jul 02\]

**URL:** <https://community.nocodb.com/t/use-eq-jul-02/585>\
**Category:** Discord-Discussions\
**Created:** [November 3, 2022, 10:21am UTC](https://community.nocodb.com/t/use-eq-jul-02/585 "2022-11-03T10:21:26Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:21am UTC](https://community.nocodb.com/t/use-eq-jul-02/585/1 "2022-11-03T10:21:26Z")

</div>

> 💁 **o1lab** _asked_

## use `eq`

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:21am UTC](https://community.nocodb.com/t/use-eq-jul-02/585/2 "2022-11-03T10:21:27Z")

</div>

> 🙋‍♂️ **Paweł** _replied_

#### it does not work

#### `{

#### “msg”: “select "sheet1"."created\_at" as "CreatedAt", "sheet1"."updated\_at" as "UpdatedAt", "sheet1"."json" as "json", "sheet1"."status" as "status", "sheet1"."receipt\_id" as "receipt\_id", "sheet1"."source\_system" as "source\_system" from "sheet1" where (((("receipt\_id" in (select "sheet1\_id" from "etsy\_payment" where "payment\_id" = ‘null’))))) order by "created\_at" asc limit 1 - invalid input syntax for integer: "null"”

#### }`

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:21am UTC](https://community.nocodb.com/t/use-eq-jul-02/585/3 "2022-11-03T10:21:28Z")

</div>

> 🙋‍♂️ **wkw** _replied_

#### \<@708648416145702952\> please create an issue. seems it s not expected. will take a look

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:21am UTC](https://community.nocodb.com/t/use-eq-jul-02/585/4 "2022-11-03T10:21:29Z")

</div>

> 🙋‍♂️ **Paweł** _replied_

#### [Filtering by null in nested column not possible using API · Issue #2516 · nocodb/nocodb · GitHub](https://github.com/nocodb/nocodb/issues/2516)

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:21am UTC](https://community.nocodb.com/t/use-eq-jul-02/585/5 "2022-11-03T10:21:30Z")

</div>

> 🙋‍♂️ **wkw** _replied_

#### thanks. will investigate

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:21am UTC](https://community.nocodb.com/t/use-eq-jul-02/585/6 "2022-11-03T10:21:31Z")

</div>

[Autogenerated from discord](https://discord.com/channels/661905455894888490/992007779973877820)

* * *

#### Join [NocoDB’s](http://www.nocodb.com/) community

[Discord](https://discord.gg/5RgZmkW) • [Twitter](https://twitter.com/nocodb) • [Reddit](https://www.reddit.com/r/NocoDB/) • [Docs](https://docs.nocodb.com/)