Automatically sort list view form by date (descending)

Questions related to using nuBuilder Forte.

Automatically sort list view form by date (descending)

Unread postby Olikun » Mon Apr 05, 2021 5:46 pm

Hello,

a new question.

How can I set it up so that the list view of the form is automatically sorted.

I only have 1 line (date) in the list

I want the current date to be at the top.

I know I can sort the list manually with one click, but I want it to happen automatically.

Is that possible?


Image
Olikun
 
Posts: 48
Joined: Wed Mar 10, 2021 3:15 am
nuBuilder Version: 4.5

Re: Automatically sort list view form by date (descending)

Unread postby kev1n » Mon Apr 05, 2021 5:53 pm

Add an ORDER BY your_date_column DESC in the Browse SQL

Code: Select all
SELECT * FROM your_table ORDER BY your_date_column DESC
kev1n
nuBuilder Team
 
Posts: 1625
Joined: Mon Oct 15, 2018 2:13 am
nuBuilder Version: 4.5

Re: Automatically sort list view form by date (descending)

Unread postby Olikun » Mon Apr 05, 2021 6:10 pm

works perfect

thanks :D
Olikun
 
Posts: 48
Joined: Wed Mar 10, 2021 3:15 am
nuBuilder Version: 4.5


Return to General

Who is online

Users browsing this forum: GlenMcCabe and 28 guests