385
Views
4
Comments
Dynamic sort is not working
Question

I have a screen Movies that has a table records that shows some info about the movies.

I have a RichWidgets\List_SortColumn in the "Title" column table header and in the "CDate" column table header of the table records to order when these table headers are clicked.

In the "Title" I have a RichWidgets\List_SortColumn with:
Source Web Block: RichWidgets\List_SortColumn
Column: "{Movies}.[Title]"
Destination: RefreshTable

In the "CDate" I have RichWidgets\List_SortColumn with:
Source Web Block: RichWidgets\List_SortColumn
Column: "{Movies}.[CDate]"
Destination: RefreshTable

 

In the preparation of the Movies screen there is an aggregate to get all the movies. This aggregate has the "Movies" entity as "Entities / Structures" and in order by there is:
"Movies.Title"
"Movies.CDate"

But its not working, when the table header is clicked the table records is not ordered. Do you know why?

2016-04-21 18-13-58
Nuno Rolo
 
MVP

Hi,

Does your sort look like this?

2018-06-05 16-54-03
Maria da Graça Peixoto

Hi! 

Did you remember to put the  

List_SortColumn_GetOrderBy(, )

RichWidgets funcion in the sorting zone of the aggregate?

Regards

Graça

UserImage.jpg
OsCaR_

Thanks, I'm using version 8 so there is no aggregates. 

2016-04-21 18-13-58
Nuno Rolo
 
MVP

Ok in that case what you need to ensure the use of the function List_SortColumn_GetOrderBy

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.