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

SQL Select Query

This SQL query will sort the datalist 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

Download the sample app:

• APP_kb_dx7_sort_multiple_columns.jwa