how to do dynamic shorting in descending order in outsystems

Hi Harish Sharma,

Can you please explain what and where you want to implement sorting ?

Pranav Pandey wrote: Hi Pranav.

i want to add dynamic shorting un descending order in year column, 

Hi Harish Sharma,

Can you please explain what and where you want to implement sorting ?



Hi Harish Sharma,,

If you want to show the list to be sorted by year by default when the page loads, then follow the steps below.

1. Go to your page preparation action and open the aggregate .

2. There go to sorting sub section and select sort option.

3. There you select the year column and press ok.

4. Then just to the right side of the sort , you will find order by option. Select descending in that and then publish it.

Please find the screenshot for reference in the attachment.


Solution

Harish Sharma wrote:

how to do dynamic shorting in descending order in outsystems

Hi Harish,

Below is the experession for applying dynamic sorting in aggregate.

List_SortColumn_GetOrderBy(Table Record Widget Id, "{Table Name}.[Field Name] DESC")

For refer below example :

SyntaxEditor Code Snippet

List_SortColumn_GetOrderBy(AudDtMainTable.Id, "{AUD_DT_MAIN}.[TABNAME] DESC")

Please let me know in case of any concern.

Thanks

AV


Solution