# Missing value when displaying even though Data shows

**URL:** <https://community.glideapps.com/t/missing-value-when-displaying-even-though-data-shows/67746>\
**Category:** Ask for Help\
**Created:** [November 13, 2023, 4:18pm UTC](https://community.glideapps.com/t/missing-value-when-displaying-even-though-data-shows/67746 "2023-11-13T16:18:16Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Trustin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trustin/32/88217_2.png) [@Trustin](https://community.glideapps.com/u/Trustin)\
**Post date:** [November 13, 2023, 4:18pm UTC](https://community.glideapps.com/t/missing-value-when-displaying-even-though-data-shows/67746/1 "2023-11-13T16:18:16Z")

</div>

So i queried a database which returns 1 of the row. But when I select to use this to display the collections it still shows all the row of data.  
Cruciferious is somewhere in the row betweem. What did i do wrong?  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/5/a5e0d62eb5bff9982a68735274d3dd9205b44a5b.png)

---

<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:** [November 13, 2023, 5:28pm UTC](https://community.glideapps.com/t/missing-value-when-displaying-even-though-data-shows/67746/2 "2023-11-13T17:28:45Z")

</div>

Show how the collection is configured. Is it using the query or is it using the entire table?

---

<div class="post-metadata">

**Author:** ![Trustin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trustin/32/88217_2.png) [@Trustin](https://community.glideapps.com/u/Trustin)\
**Post date:** [November 14, 2023, 12:09am UTC](https://community.glideapps.com/t/missing-value-when-displaying-even-though-data-shows/67746/3 "2023-11-14T00:09:09Z")

</div>

As seen in above, the Query only has Cruciferous as a result.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/9/59fbc321eea623e5f45a92c4bb6f8282e70685ac.png)

This is the collection that i am showing…it display all the rows…but I limit it to only 1…and the first row which is the Medium Fruit is displayed…Not filter is applied yet.  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/3/737ec05827994479e1d16d7b3af1f6e45722f572.png)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [November 14, 2023, 12:22am UTC](https://community.glideapps.com/t/missing-value-when-displaying-even-though-data-shows/67746/4 "2023-11-14T00:22:06Z")

</div>

No obvious reasons to me. Have you tried refreshing the browser? Does any of the user rows return a full list of data in the query column?

---

<div class="post-metadata">

**Author:** ![Trustin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trustin/32/88217_2.png) [@Trustin](https://community.glideapps.com/u/Trustin)\
**Post date:** [November 14, 2023, 1:40pm UTC](https://community.glideapps.com/t/missing-value-when-displaying-even-though-data-shows/67746/7 "2023-11-14T13:40:05Z")

</div>

Hey~ Apparently the category even though it shows the result from my fetchJSON. it appears to be empty. See the template I used to display [Food] is a [Category]  
[Food] is User selected food which is Lacinato Kale  
[Category] is reading the value from fetchJSON which in the data is displaying Kale. See below  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/7/37d0c806e7a67083c61b34c8b410d4637431b6dc.png)  
e  
See last row where my User row is.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/5/b5a092b7d0363c60a3c57a96b796d3bd73ac50d0.png)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [November 14, 2023, 10:40pm UTC](https://community.glideapps.com/t/missing-value-when-displaying-even-though-data-shows/67746/8 "2023-11-14T22:40:29Z")

</div>

I’m still unclear about your data structure. Can you explain:

- What column “appears to be empty” in your screenshot?
- What is your current flow for the user on the front end?