Android Example [B4X] Supabase - Database OrderBy

[B4X] Supabase - The Open Source Firebase alternative

Supabase is an open source Firebase alternative. It provides all the backend services you need to build a product. Supabase uses Postgres database with real-time capabilities. Basically, supabase provides an interface to manage postgres database that you can use to create table and insert, edit...

www.b4x.com

You can order by just one column, or with multiple columns.

Available sorting commands:

• desc
  • To sort the records in descending order
• asc
  • To sort the records in ascending order
• nullsfirst
• nullslast

Example of order by with one column:

"Tasks_Id.desc"

    Dim Query As Supabase_DatabaseSelect = xSupabase.Database.SelectData
    Query.Columns("*").From("dt_Tasks")
    Query.OrderBy("Tasks_Id.desc")
    Wait For (Query.Execute) Complete (DatabaseResult As SupabaseDatabaseResult)
    xSupabase.Database.PrintTable(DatabaseResult)

Example of order by with multiple columns:

"Tasks_Id.desc,Tasks_Name.asc"

    Dim Query As Supabase_DatabaseSelect = xSupabase.Database.SelectData
    Query.Columns("*").From("dt_Tasks")
    Query.OrderBy("Tasks_Id.desc,Tasks_Name.asc")
    Query.Limit(1)
    Wait For (Query.Execute) Complete (DatabaseResult As SupabaseDatabaseResult)
    xSupabase.Database.PrintTable(DatabaseResult)