Skip to Content (Press Enter)
2019-02-07 07-58-20
EnthusiaticNewbie
798Views
5Comments
Solved
Regarding dynamic sort
Question

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?


screenshot.png
0
0
27 Aug 2019
Copy Link
2020-02-28 09-46-54
Eduardo Jauch
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.

See solution in context
2
0
27 Aug 2019
Copy Link
2023-05-23 04-55-55
Wasimkhan Syed Abuthahir

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


ListSort.PNG
0
0
27 Aug 2019
Copy Link
2021-09-06 15-09-53
Dorine Boudry
 
MVP

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

0
0
27 Aug 2019
Copy Link
2024-05-03 14-03-28
Sudip Dey

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

0
0
27 Aug 2019
Copy Link
2020-02-28 09-46-54
Eduardo Jauch
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.

2
0
27 Aug 2019
Copy Link
2023-05-23 04-55-55
Wasimkhan Syed Abuthahir

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


ListSort.PNG
0
0
27 Aug 2019
Copy Link
2019-02-07 07-58-20
EnthusiaticNewbie

Eduardo got it right. 

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

0
0
27 Aug 2019
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.