# Using filter with LTAR or Lookup column \[Sep 03\]

**URL:** <https://community.nocodb.com/t/using-filter-with-ltar-or-lookup-column-sep-03/664>\
**Category:** Discord-Discussions\
**Created:** [November 3, 2022, 10:47am UTC](https://community.nocodb.com/t/using-filter-with-ltar-or-lookup-column-sep-03/664 "2022-11-03T10:47:12Z")\
**Posts on this page:** 5\
**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:47am UTC](https://community.nocodb.com/t/using-filter-with-ltar-or-lookup-column-sep-03/664/1 "2022-11-03T10:47:12Z")

</div>

> 🙋‍♂️ **4oject** _asked_

## Hi people, i am new NocoDB user, and i want to **query my data with nested value** , but it is not working, what can i do, who can help me to understand what i am doing wrong ? 🥲

#### I have tried it in Swagger(parameter was **nested%5Bcreatedby%5D%5Bwhere%5D=%28username%2Ceq%2Cfirstuser%29** ), in Postman(parameter was **nested[createdby][where]=username,eq,firstuser** ), none of them gave me what i want.

#### Their response was just raw json.

#### When i use nested[createdby][fields]=username it works.

#### Where filtering works in GUI.

#### But in nested querying it is not working, what can i do ?

---

<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:47am UTC](https://community.nocodb.com/t/using-filter-with-ltar-or-lookup-column-sep-03/664/2 "2022-11-03T10:47:13Z")

</div>

> 👨‍💻 **pranavxc** _replied_

#### `nested` is for applying filter on nested level list/data, if you want to filter root level data do following =\> `where=(createdby,eq,firstuser)` (Assuming `username` is primary value)

#

---

<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:47am UTC](https://community.nocodb.com/t/using-filter-with-ltar-or-lookup-column-sep-03/664/3 "2022-11-03T10:47:15Z")

</div>

> 👨‍💻 **pranavxc** _replied_

#### if username is not primary value then create a lookup column and use it within where query

#

---

<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:47am UTC](https://community.nocodb.com/t/using-filter-with-ltar-or-lookup-column-sep-03/664/4 "2022-11-03T10:47:16Z")

</div>

> 👨‍💻 **pranavxc** _replied_

#### like `(lookupColumn,eq,firstuser)`

#### where `lookupColumn` is a lookup column to `createdBy => username`

#

---

<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:47am UTC](https://community.nocodb.com/t/using-filter-with-ltar-or-lookup-column-sep-03/664/5 "2022-11-03T10:47:17Z")

</div>

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

* * *

#### 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/)