202
Views
8
Comments
Solved
Reactive Apps - Table OnSort

Hi - I have a GroupBy in an Aggregate of 4-columns. 

This then exposes only 4 columns with Alias-names in its' output List.

The table then only recognizes these alias-names and when a 'Sort' event is triggered; uses said names as the SortBy parameter. Which - for some reason - the same Aggregate doesn't recognize.

But - when I try to substitute the Column property of the Column-header with one it does recognize it rejects it as, clearly, it hasn't been exposed by the Aggregate's output List. 


So how can I solve this Catch-22 situation?


Thanks.

Rank: #2215
Solution

Tiago Simões wrote:

Hi Oliver,

You can try to set the TableSort variable to to "GroupBy({Entity}.[Attribute])", not sure if it works. In any case that looks like an issue, could you submit it through Service Studio and state that you can't dynamically sort a grouped attribute in a reactive table widget?

Thanks,
Tiago Simões

Hi Tiago,

Created Support Case #2329414

It didn't work - what you suggested.


Olivier Levine wrote:

Hi - I have a GroupBy in an Aggregate of 4-columns. 

This then exposes only 4 columns with Alias-names in its' output List.

The table then only recognizes these alias-names and when a 'Sort' event is triggered; uses said names as the SortBy parameter. Which - for some reason - the same Aggregate doesn't recognize.

But - when I try to substitute the Column property of the Column-header with one it does recognize it rejects it as, clearly, it hasn't been exposed by the Aggregate's output List. 


So how can I solve this Catch-22 situation?


Thanks.

https://success.outsystems.com/Documentation/11/Developing_an_Application/Design_UI/Creating_and_editing_Tables/Table_pagination_and_sorting


Rank: #2215

Bruno Miguel das Neves Rendeiro wrote:

Olivier Levine wrote:

Hi - I have a GroupBy in an Aggregate of 4-columns. 

This then exposes only 4 columns with Alias-names in its' output List.

The table then only recognizes these alias-names and when a 'Sort' event is triggered; uses said names as the SortBy parameter. Which - for some reason - the same Aggregate doesn't recognize.

But - when I try to substitute the Column property of the Column-header with one it does recognize it rejects it as, clearly, it hasn't been exposed by the Aggregate's output List. 


So how can I solve this Catch-22 situation?


Thanks.

https://success.outsystems.com/Documentation/11/Developing_an_Application/Design_UI/Creating_and_editing_Tables/Table_pagination_and_sorting


Yes - thank you - I'm well aware how it works. 

This is a special-case; please read my question carefully.


Staff
Rank: #20

Hi Oliver,

You can try to set the TableSort variable to to "GroupBy({Entity}.[Attribute])", not sure if it works. In any case that looks like an issue, could you submit it through Service Studio and state that you can't dynamically sort a grouped attribute in a reactive table widget?

Thanks,
Tiago Simões

Rank: #2215
Solution

Tiago Simões wrote:

Hi Oliver,

You can try to set the TableSort variable to to "GroupBy({Entity}.[Attribute])", not sure if it works. In any case that looks like an issue, could you submit it through Service Studio and state that you can't dynamically sort a grouped attribute in a reactive table widget?

Thanks,
Tiago Simões

Hi Tiago,

Created Support Case #2329414

It didn't work - what you suggested.


Rank: #26286

Olivier Levine wrote:

Tiago Simões wrote:

Hi Oliver,

You can try to set the TableSort variable to to "GroupBy({Entity}.[Attribute])", not sure if it works. In any case that looks like an issue, could you submit it through Service Studio and state that you can't dynamically sort a grouped attribute in a reactive table widget?

Thanks,
Tiago Simões

Hi Tiago,

Created Support Case #2329414

It didn't work - what you suggested.


Hi ,

I am facing the same issue of applying sorting. Can you please help me out with how you resolved this issue.

Thanks


Rank: #600

Meetali Gupta wrote:

Olivier Levine wrote:

Tiago Simões wrote:

Hi Oliver,

You can try to set the TableSort variable to to "GroupBy({Entity}.[Attribute])", not sure if it works. In any case that looks like an issue, could you submit it through Service Studio and state that you can't dynamically sort a grouped attribute in a reactive table widget?

Thanks,
Tiago Simões

Hi Tiago,

Created Support Case #2329414

It didn't work - what you suggested.


Hi ,

I am facing the same issue of applying sorting. Can you please help me out with how you resolved this issue.

Thanks


Hi,

any news on this?
I am struggling with the same issue...

Thx

Rank: #26286

Rob Poels wrote:

Meetali Gupta wrote:

Olivier Levine wrote:

Tiago Simões wrote:

Hi Oliver,

You can try to set the TableSort variable to to "GroupBy({Entity}.[Attribute])", not sure if it works. In any case that looks like an issue, could you submit it through Service Studio and state that you can't dynamically sort a grouped attribute in a reactive table widget?

Thanks,
Tiago Simões

Hi Tiago,

Created Support Case #2329414

It didn't work - what you suggested.


Hi ,

I am facing the same issue of applying sorting. Can you please help me out with how you resolved this issue.

Thanks


Hi,

any news on this?
I am struggling with the same issue...

Thx


Hi Rob Poels,

For this, we also need to apply a filter on the id attribute of aggregate which is grouped by of the main table. So i applied Z->A sort on the id attribute(which was grouped by) of the main entity of my aggregate and it worked fine for me.

Thanks 

Rank: #31164

I had the same issue. The workaround I did and worked for me was to remove and add mannually the Sort By attribute in the aggregate.

Literaly remove the TableSort attribute and add it again.