In this tutorial, we will demonstrate how to sort a list by multiple columns. In this sample, we will focus on sorting by three columns: Country, first name, and last name.

Form Design

Knowledge Base for DX 8 > Sorting by Multiple Columns > image2023-6-28_13-32-38.png

List Design

Currently, Joget doesn't offer the option to directly sort the list by multiple columns natively, however there is a method to do so by using the Database SQL Query.

Knowledge Base for DX 8 > Sorting by Multiple Columns > image2023-6-28_13-35-19.png

Knowledge Base for DX 8 > Sorting by Multiple Columns > image2023-6-28_13-37-12.png

SQL Select Query

This SQL query will sort the list by country, then first name, then last name.

SELECT c_country
  , c_first_name
  , c_last_name
FROM
    (
        SELECT c_country
          , c_first_name
          , c_last_name
        FROM
            app_fd_details
        ORDER BY
            c_country asc
          , c_first_name asc
          , c_last_name asc
        LIMIT 18446744073709551615
    )
    alias

Runtime

Knowledge Base for DX 8 > Sorting by Multiple Columns > image2023-6-28_13-41-45.png

Download the sample app:

APP_kb_dx8_sort_multiple_columns.jwa