how order a related table in a select query in Dart/Flutter
hi guys, i'm performing this query:
works fine, but i want to order this query based on "mensagem_app.id" descending , ( this table shows the user messages inside the app , so i want to order descending by its id to shor firstly the newer messages )
please help !
await _Supabase_.getclient().from('user_profile').select('*,estabelecimento(id,nome), mensagem_app(*)').eq('auth_id', data['id']);works fine, but i want to order this query based on "mensagem_app.id" descending , ( this table shows the user messages inside the app , so i want to order descending by its id to shor firstly the newer messages )
please help !
