| 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
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
| Code Block | ||
|---|---|---|
| ||
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 |
...