Versions Compared

Old Version 3

changes.mady.by.user Imran Uzair

Saved on

compared with

New Version Current

changes.mady.by.user PT

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
English
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

Image Modified

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.

Image Modified

Image Modified


SQL Select Query

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

Code Block
titlelanguageSQL Querysql
SELECT c_country
  , c_first_name
  , c_last_name
FROM
   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: