...
| Warning |
|---|
This only serves as a temporary solution until a better solution is available. |
This article showcase showcases the implementation of sort sorting the order of multiple column columns in a list. This approach is useful when you want to create a ranking or ordering of your data with multiple levels of priority. Each column in the ORDER BY clause contributes to the sorting order, and the result is a well-defined sequence of rows in the result set.
...
Go to list then go to Data and select Database SQL Query as the source of data as shown in figure Figure 2.
Figure 2: Select Database SQL Query
...
Once inside the configuration, make changes to the following script and insert it into the SQL SELECT Query field. Make sure to insert the correct primary key as shown in figure 3.
...
Set the Order and Order by properties in the list settings
Figure 4: List properties configuration
...