You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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


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.


SQL Select Query

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

SQL 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:


  • No labels