I currently have a distance column thats calculating the distance between whatever location the User inputs, and the stores location. I am then running a query(without getting too much into the backend filtering, a query is needed.) and sorting said query by that distance column. This allows the customer to see the stores closest to them. This has proven to be very unreliable, I can enter a cities name and it works perfectly, enter a different city and it works, then enter the intial cities name and suddenly the distance is over 10000kms, and then it just stops working for any input until you fully refresh the page. The weird part about this is, its correct in the query. If I go over and look at the query in data, the order is perfect. I then go back to the collection in app, and the order is wrong. So for some reason it sometimes works in the layout, despite always being correct in the data query. You type in a city it works perfectly, you clear everything with a button action and input the same city and it suddenly won’t work. No data has changed in that time. Seriously stumped.

[image] How to open a support ticket? Ask for Help Please note: the option to create a support ticket is only available if your App is in a Pro, Business or Enterprise Team. If you need help with a Billing Issue (on any plan), you should open a Billing Enquiry via the Glide Support Page. To create a Support Ticket: Open the App that is giving you problems, and go to Settings → Contact Support: [CleanShot 2023-08-16 at 16.24.33@2x] Glide will prompt you to create a support link for your App. Click on Create Link: [CleanShot 2023-08-16 at… Please submit a ticket. Thanks a lot!

Query filtering by distance not reliable

Ask for Help

ThinhDinh April 3, 2024, 12:45am 2

Please submit a ticket. Thanks a lot!

Topic		Replies	Views
Sort by distance away crashes Ask for Help	4	136	January 19, 2024
Sort Data by Distance Ask for Help	7	100	April 4, 2026
Distance button not working Ask for Help	16	318	December 6, 2023
Nesecito ayuda configuracion distancia pqrq usuarios Ask for Help	1	47	November 11, 2025
Sorting SQL data by user‑specific Distance column Ask for Help	6	132	December 16, 2025

Query filtering by distance not reliable

Related topics