How can I order by publication, then by title in supabase?

我怎么才能先按出版物排序，再按标题排序呢？

This is wrong:

这是错误的：

.order('publicationDate', { ascending: false }, 'title', { ascending: true });

If I make them separate lines, the 2nd one overrides the first.

如果我将它们分开，第二行将覆盖第一行。

According to the comment in the source code of @supabase/postgres-js package
the only way to order by multiple columns is by using .order method multiple times.

根据@supabase/postgres-js包源代码中的注释，按多列排序的唯一方法是多次使用.order方法。

I sort of just wrote this without testing it, so it might not work (syntax), but let me know what happens!

我只是在没有测试的情况下编写了这段代码，所以它可能无法工作(语法)，但请让我知道会发生什么！

Some Context:

一些背景信息：

In Supabase, which uses PostgREST behind the scenes, when you want to order by multiple columns, you should use an array.

在后台使用PostgREST的Supabase中，当您想要按多列排序时，您应该使用数组。

The .order() function enables users to order by multiple columns by supplying an array of columns and, optionally, an array of corresponding ordering directions.

.order()函数使用户能够通过提供列数组和相应排序方向数组(可选)来按多列排序。

Now the code:

现在代码如下：

.order([{ column: 'publicationDate', order: 'desc' }, { column: 'title', order: 'asc' }])

So, your full Supabase query might look something like this:

因此，完整的Supabase查询可能如下所示：

supabase
  .from('yourTableName')
  .select('*')
  .order([{ column: 'publicationDate', order: 'desc' }, { column: 'title', order: 'asc' }])

.order([{ column: 'publicationDate', ascending: false }, { column: 'title', ascending: true }])

This code will first order your results by publicationDate in descending order (most recent first) and then, for items with the same publication date, it will further order them by title in ascending order (alphabetical order). This should give you the desired ordering for your Supabase results.

这段代码将首先按照publicationDate以降序（最近的在前）对结果进行排序，然后，对于具有相同发布日期的项目，它将进一步按照标题以升序（字母顺序）进行排序。这将为您的Supplement结果提供所需的排序。