Skip to main content
Browse Documentation
Ordering

ZenQL search – ordering

Created by r.saunders, last modified by r.bromley on 13 Feb 2022

Order list: ORDER BY {}

Order a list of results by a field of the data returned – supports text, numbers and dates.

  • Order plants by their title.
    sys.contentTypeId = plants ORDER BY entryTitle
  • Order plants by their title in alphabetical order, then by their price in descending order highest price to lowest.
    sys.contentTypeId = plants ORDER BY entryTitle asc, price desc

Ascending order: ASC

Order the list of results in ascending order.

  • Order plants by their title (A-Z).
    sys.contentTypeId = plants ORDER BY entryTitle asc
  • Order plants by their price, lowest to highest.
    sys.contentTypeId = plants ORDER BY price asc

Descending order: DESC

Order the list of results in descending order.

  • Order plants by their title (Z-A).
    sys.contentTypeId = plants ORDER BY entryTitle desc
  • Order pots by their height, tallest to shortest.
    sys.contentTypeId = pots ORDER BY height desc