# BUG? - Query **URL:** \ **Category:** Ask for Help\ **Created:** [May 5, 2023, 11:08pm UTC](https://community.glideapps.com/t/bug-query/61410 "2023-05-05T23:08:24Z")\ **Posts on this page:** 7\ **Page:** 2
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [May 9, 2023, 10:12pm UTC](https://community.glideapps.com/t/bug-query/61410/21 "2023-05-09T22:12:31Z")
Hola @Mark I think I was able to isolate my problem with Query column but now I don’t know if this behavior is normal by design or a real bug. This my data to test, the data is generated by API request fired every 30 sec and of course, the data is going to change. Due to values depend on their timestamp, their positions (row) are different on each API request (30 sec) from top to bottom… ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/6/56876cedc4a9aff85bb0d52e5ed8e6718723d36f.jpeg) If I create a Query using a filter with a real column (text/number) the result is correct, no problem here: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/3/9310b7096997be0a608c4466479eae8fb412a1f8.png) but if I use a **computed column to filter my data** , the results are insane: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/a/3ab9f490466ef5a91e8e175cbb88ef98c31982c1.png) In this case, when the relation is first created, the results are correct but when the data is changed by a new API request (every 30 sec), the relation freezes and the results are not updated. My question is: Can a Query column work with a computed column as filter? I hope so! Thanks! ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [May 10, 2023, 6:47pm UTC](https://community.glideapps.com/t/bug-query/61410/22 "2023-05-10T18:47:42Z")
We deployed a fix today. Would you all mind checking whether you still see these bugs, please? ---
**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:** [May 10, 2023, 8:14pm UTC](https://community.glideapps.com/t/bug-query/61410/23 "2023-05-10T20:14:29Z")
First pass thru the test app and is rendering correct AND my app (using lots and lots of compute columns and lookup tables) is rendering correctly. I have about 25 more dashboard data instances I can check later this afternoon which are all based on computed columns and lookups and will verify they render correctly for my use case - SO FAR SO GOOD. BTW - the UI for query is off-the-charts excellent - both intuitive and functional. Congrats to engineering and product management and the UI team for the great work. ---
**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:** [May 10, 2023, 11:46pm UTC](https://community.glideapps.com/t/bug-query/61410/24 "2023-05-10T23:46:40Z")
I tested all, here are the results. I had built ‘tags’ to match against so I could use relations to ‘roll-up’ to create the ‘scorecards’. Hundreds and hundreds of tags so I could match WEEK, MONTH, QUARTER, YEAR, CHANNEL, PARTNER, SOURCE, TERRITORY and their permutations (using array matching which is also fantastic). All to get to the 60 or so data points I wanted to show plus ‘future’ reporting. The TAG method was very labor intensive and error prone which I just discovered. I moved all the ‘scorecards’ to Queries and just checked the two results. I found 2 errors in the TAG method (wrong template data and wrong logic) and 1 error in the Query method (I need another filter to get the correct result). Using Queries was a 50x time/logic improvement over the TAG method. My only concern is performance - the TAG method was **fast** (but also ridiculously unmanageable). The query method on my small data sets is fine and I am sure that Glide will continue to improve its performance. It is a game-changing feature and so intuitive. @david and @Mark - fantastic execution by the entire Glide team. I will wait for others to chime in but from my perspective I mark this as the solution. ---
**Author:** ![BLA\_68](https://avatars.discourse-cdn.com/v4/letter/b/977dab/32.png) [@BLA\_68](https://community.glideapps.com/u/BLA_68)\ **Post date:** [May 11, 2023, 1:19am UTC](https://community.glideapps.com/t/bug-query/61410/25 "2023-05-11T01:19:10Z")
@Mark and team: Great work. The two different examples where query results would not display have been resolved! Thank you! ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [May 11, 2023, 3:35am UTC](https://community.glideapps.com/t/bug-query/61410/26 "2023-05-11T03:35:54Z")
Yes @Mark , now the Query column works perfectly! Thanks a lot! ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [May 12, 2023, 3:36am UTC](https://community.glideapps.com/t/bug-query/61410/27 "2023-05-12T03:36:23Z")
Closed on May 12, 2023, 3:36am UTC This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed. [Previous page](https://community.glideapps.com/t/bug-query/61410.md?page=1)