Versions Compared

Old Version 2

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 naturallynatively, however there is a method to do so by using the JDBC Datalist Database Binder.

Image Modified

Image Modified


SQL Select Query

...

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: