Method orderBy

lib/model.ts:492–516

Order query results based on a field name and an optional direction. * * await Flight.orderBy("departure").all(); * * await Flight.orderBy("departure", "desc").all(); * * await Flight.orderBy({ departure: "desc", destination: "asc" }).all();

(
    this: T,
    fieldOrFields: string | OrderByClauses,
    orderDirection: OrderDirection = "asc",
  )

   *     await Flight.orderBy({ departure: "desc", destination: "asc" }).all();
   */
  static orderBy<T extends ModelSchema>(
    this: T,
    fieldOrFields: string | OrderByClauses,
    orderDirection: OrderDirection = "asc",
  ) {
    if (typeof fieldOrFields === "string") {
      this._currentQuery.orderBy(
        this.formatFieldToDatabase(fieldOrFields) as string,
        orderDirection,
      );
    } else {
      for (
        const [field, orderDirectionField] of Object.entries(
          fieldOrFields,
        )
      ) {
        this._currentQuery.orderBy(
          this.formatFieldToDatabase(field) as string,
          orderDirectionField,
        );
      }
    }

    return this;
  }

  /** Group rows by a given field.
   *