Order

Sometimes you will need to get your rows from table in defined order. You can reach that using parameter order in query. Ordering can be done in two directions: ascending (ASC) and descending (DESC)

Say, to display price from bigger to less you can use such expression:

const query = {
  filter: {
    order: [
      { column: 'price', direction: 'DESC' }
    ]
  }
}

...or such one:

const query = {
  filter: {
    order: [
      { column: 3, direction: 'DESC' }
    ]
  }
}

...also such one:

const query = {
  filter: {
    order: [
      { column: { column: 'price' }, direction: 'DESC' }
    ]
  }
}

...and even such one:

const query = {
  filter: {
    order: [
      { column: { func: 'LOWER', args: [{ column: 'name' }] }, direction: 'DESC' }
    ]
  }
}

To use default ordering (ASC) you can:

...pass it explicitly:

const query = {
  filter: {
    order: [
      { column: 'price', direction: 'ASC' }
    ]
  }
}

...or omit direction parameter:

const query = {
  filter: {
    order: [
      { column: 'price' }
    ]
  }
}

...or just pass column name only:

const query = {
  filter: {
    order: 'price'
  }
}

...or pass DB Column type

const query = {
  filter: {
    order: { column: 'price' }
  }
}

...also you can pass number of column instead of its name:

const query = {
  filter: {
    order: 3
  }
}

Simple rule: to make ordering by just one field use simple types like column name, number of column or DB Column, to order by several fields - use an array of that values.

For more details see DB Order By Clause type description.

Go to next chapter to understand how to use group parameter.