a year ago · My personal email is - John (at) Cannon (dot) cc

Can I make simple queries with supabase?

Database & APIs

I have been trying to test Flutter Flow and different database systems for an app I am developing. It struck me yesterday that I cannot perform the following simple query:

SELECT steps
FROM distances
WHERE "fromlocation" = varStartingPoint
AND "tolocation" = varEndingPoint;

Instead, when I do a backend query I get the entire record and have to write custom code to parse the data and find the correct data element.

That can't possibly be true, is it??

What have you tried so far?

I've read the documentation https://docs.flutterflow.io/data-and-backend/supabase/supabase-database/retrieving-data
- I've consulted several AI's for help.
- Note in the screenshot below, there is no way to specify which attribute to select from the result of the query.

Did you check FlutterFlow's Documentation for this topic?

Yes

3 replies