Collapse Expand group property

[cvo]

Hi,

I'd like to have a collapse/expand group property.
I often put in the table toolbar an expand/collapse button to make easier the navigation in the data.
This property would make things easier.

Regards

[Jack_T]

Hi @cvo,

Could you give me more details on what group you are looking to expand/collapse?

Are you thinking about the whole table component? Or for the collapsible rows of a table?

[Infinitybht]

Hello CVO,
I believe what you are looking for is to add a button to the toolbar. This button will allow the grouping of one or more columns.

Also, the Table comment has a function "SetGrouping()" which helps you control the grouping of the table dynamically from other queries or components.

Hope this helps!
Correct me if I didn't understand your question.

[cvo]

Hi,

To help my users navigate in a table with several thousand rows, I put buttons in a table toolbar to allow them to create and clear row groups on their own.
I add a collapse/expand button that change the "Expand groups by default" option based on a defined variable.
This way users can easily navigate, scroll, locate, select the rows they way to update. Then make groups based on other columns.

Unfortunately, when groups are suppressed the reference to the variable used by the ""Expand groups by default"" disappear and the button "collapse/expand" has no more effect.
so a real property instead of the "expand groups" parameter would be great.

Regards

[Jack_T]

Hi @cvo,

Ok I understand this better, thank you for the explanation and screen shots.

So you have the 'Group By' filter from the table tool bar which works fine.

Then under the Table's advanced settings, you have Group By 'Datasource' and inside of 'Expand rows by default' you are passing in a value with {{}}.

But the issue is that when the groups "are suppressed" the value in the {{}} used inside 'Expand rows by default' disappears

Could you elaborate more on what event is causing the groups to be suppressed?

Not sure what I should be looking for in the third image but the fourth has custom edit button, is that the button that is suppressing doing the suppressing?

With the "collapse/expand" button supplying the value, but instead of this button being used to toggle the collapse/expand you want a table1.expandGroups parameter instead. Which would work as a variable you can toggle between true and false to control if the current groups that are applied to the table are expanded or collapsed, correct?

Would this be a boolean and then another value sets the groups?

[cvo]

Hi Jack

Sorry, I should have taken the time to explain the screenshots.

1. raw list without grouping

2 and 3) by defining grouping and playing with expand/collapse, users can easily navigate in a large dataset. it's very efficient and intuitive for users.

4. The way the toolbar button works to expand or collapse the groups on the first 2 levels. It uses a variable

5. the way I handle the default expand option with a variable in the advanced settings of the table.

"But the issue is that when the groups "are suppressed" the value in the {{}} used inside 'Expand rows by default' disappears"
That's it, I need first to define a variable and second I loose the reference to this variable. so the toolbar button has no more effect.
What would be the best feature : a method (toggle), a parameter ? I don't know.

Regards

[Jack_T]

Ahhhhh ok thank you so much for the further explanation.

This is making a lot more sense now apologies for asking so many questions. A video recoding would have been perfect to explain this for next time.

So it sounds like the two ways of controlling grouping rows and expanding/collapsing rows are conflicting with each other. Tool bar control vs Table Advanced control.

The table component does have a method for expanding rows and collapsing rows, but this is limited in terms of selecting which rows to apply these actions to to the specifiers of 'index', 'key' or 'all'.

table1.expandRows({mode: 'all'})

and table1.collapseRows({mode: 'all'})

If you want to have a button that runs 'expand all' or 'collapse all' you can have to run a script with one of these table methods instead of having a variable and threading it into the table's advanced settings!

[Jack_T]

I thought you were asking for a specific way to specify which groups would open and close.

Would you also like to request that these two methods take in another argument where you can programmatically specify the group names of the columns that make up the groups?

So that you can only close specific groups and not be limited to 'expand all' or 'collapse all'.

[cvo]

Hi,

I would rather look for a way to collapse/expand to a group level.
Users don't always all the group names but they know which level contains the information they're looking for

Regards

[Jack_T]

@cvo Ah ok I see, thanks for explaining that!

I can add that to the feature request, so that the expand/collapse functions can take 'group' arguments to add greater specificity for your use case.

If you could share the event handler from your image #4 that could be helpful as well for explaining your work around and how we can improve it to the engineers!

[cvo]

Hi,
The event is quite simple.
I justchange the value of a variable.
This variable is the one used by fx'Expand rows by default'

Regards