`query.orderBy()` usage

[hakimio]

query.orderBy() has a lot of method overrides. So, I tried some:

• query.orderBy('createdAt desc') -> correct result: createdAt desc
• query.orderBy({createdAt: 'desc'}) -> incorrect result: createdAt/desc
• query.orderBy(['createdAt', 'desc']) -> incorrect result: createdAt,desc
• query.orderBy(builder => builder.e().descending(builder.t.createdAt)) -> correct result: createdAt desc

Am I misunderstanding some of the signatures or are they generating incorrect output? If my usage is wrong, what's the correct orderBy() usage with object and tuple syntax?

[hakimio]

Ok, found the answer:

• for tuple syntax it has to be array in an array:

  query.orderBy([ ['createdAt', 'desc'] ]);

• for the nested object, it can be used this way:

  query.orderBy({
  company: {
      address: [['country_code', 'desc']]
  }
  });