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

Form Design

Datalist Design

Currently, Joget doesn't offer the option to directly sort the datalist by multiple columns natively, however there is a method to do so by using the JDBC Datalist Database Binder.

SQL Select Query

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

Download the sample app:

• APP_kb_dx7_sort_multiple_columns.jwa