Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

How to order a table with multiple field? I tried to add multiple order(), but that doesn't seem to work

Hello <@695784618951180289>!
This thread has been automatically created from your message in <#843999948717555735> a few seconds ago.

We have already mentioned the <@&951828363943759883> so that they can see your message and help you as soon as possible!

**Want to unsubscribe from this thread?**
Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates.

**Want to change the title?**
Use the ``/title`` command!

**We have solved your problem?**
Click the button below to archive it.

What happens when you call `order()` twice?  Can you post the sample code?

I receive a 400. order[0] = {field: "col1", asc: false}

Here's an example someone gave me that works:
```
supabase
.from("parents")
.select("*, children(*)")
.order('name', { ascending: false})
.order('name', { foreignTable: 'children', ascending: false})
```

Can you try simplifying it or hard-coding some values to test it first?

It's because it is dynamic. But your example made me realize that I think I don't include all the columns I need in the select...

I'm not sure what's happening with your `foreignTable}:` part there.

Ohhh! That part is just an helper from Webstorm IDE. {ascending, nullsFirst, ForeigneTable}: is not in the code, it just show what property are available

or have you figured it out already 🙂 ?

Yeah! My code was working, but I had a typo in the config file containing columns name 😮 Thank you!

Thread was archived by <@695784618951180289>. Anyone can send a message to unarchive it.