# Query - Single Row 🆕

**URL:** <https://community.glideapps.com/t/query-single-row/81020>\
**Category:** General\
**Created:** [March 27, 2025, 2:39pm UTC](https://community.glideapps.com/t/query-single-row/81020 "2025-03-27T14:39:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\
**Post date:** [March 27, 2025, 2:39pm UTC](https://community.glideapps.com/t/query-single-row/81020/1 "2025-03-27T14:39:33Z")

</div>

Nice 👌

How will you use it?

> <https://x.com/glideapps/status/1905255366826373536?s=46&t=syK5MRhmuq-HlKDqeEHv1g>

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [March 27, 2025, 2:41pm UTC](https://community.glideapps.com/t/query-single-row/81020/2 "2025-03-27T14:41:36Z")

</div>

Use it like a Single Relation, but with better filtering of data to get the single row you want.

For example, lookups that are single values instead of arrays, or being able to set columns in the row through the query.

---

<div class="post-metadata">

**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\
**Post date:** [March 27, 2025, 3:08pm UTC](https://community.glideapps.com/t/query-single-row/81020/3 "2025-03-27T15:08:20Z")

</div>

Doesn’t this save the additional complexity for use cases where after running a Query which only returns a single row (I have loads of use cases) you then have to use “Single Value” to get the row that so you can use it for Lookup, etc?

Or is there another use-case in addition?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [March 27, 2025, 3:20pm UTC](https://community.glideapps.com/t/query-single-row/81020/4 "2025-03-27T15:20:24Z")

</div>

> [@MattLB](#):
>
> you then have to use “Single Value” to get the row that so you can use it for Lookup, etc

Previously, a Single Value column could be substituted for a Lookup column when using a Query. You wouldn’t have needed to pass it through a single value row first to get the Lookup. You could just use the single value column pointing to a specific column through the query. However, I could see a case if you wanted to set column values through the query…then you would have needed the single value row column as well.

Now you can directly use a lookup or a single value column to get the same result, as well as set column values directly through the query. It’s basically a single relation with more robust filtering.