I tried to search the forum based on the keywords of "List_SortColumn_GetOrderBy" and "dynamic sort" but i cannot find a relevant result except for the official guides,

https://success.outsystems.com/Documentation/11/Developing_an_Application/Use_Data/Query_Data/Sort_Results_in_an_Aggregate

https://www.outsystems.com/help/servicestudio/9.0/Using_Data/aggregates/Sorting_Results.htm

Referring to the screenshot I attached,

Regardless I put "{Person}.[Surname] ASC" or "{Person}.[Surname] DESC", the preview data does not show up correctly.

Can someone point out my error?

Hi Newbie,


there's no error, I don't think the platform executes the dynamic sort part while previewing an aggregate in Service Studio.  So you'll have to publish to see the effect of what you're doing.


Dorine

Hi Newbie,

You have to create a table record ointing with that entity and publish it in service studio by using 1 click publish. and after publishing click to open it on the browser. You will able to see the sorting there. 


Thank You,

Sudip

Solution

Hi EnthusiaticNewbie

As this is defined "dynamically", you have to set a value in the Test tab in order to execute the order in the preview:

You will find it there and you can set the "{Person}.[Surname] ASC" in the appropriate test input.

Hipe this helps.

Cheers.

Solution

Eduardo Jauch wrote:

Hi EnthusiaticNewbie

As this is defined "dynamically", you have to set a value in the Test tab in order to execute the order in the preview:

You will find it there and you can set the "{Person}.[Surname] ASC" in the appropriate test input.

Hipe this helps.

Cheers.

Hi EnthusiaticNewbie,

As Eduardo Jauch said you can set the column name in Test value to see the result while previewing in aggregate.

Thanks and Regards,

Wasim Khan S


Eduardo got it right. 

Both dorine and wasim also got it right but eduardo is the closest without having to publish to test.