How to FullCollaps / FullExpand grouped TUniDBGrid ?

[Freeman35]

Hello,

How to FullCollaps / FullExpand grouped TUniDBGrid ? I wanna after open dataset, Collaps all group. How can I do this?

Thank you.

[eduardosuruagy]

  dbgrid_cadastro.FullExpand;
  dbgrid_cadastro.FullCollapse;
 

[Freeman35]

Hello eduardosuruagy,

I'm using v.1480. And asked for TUniDBGrid, are you sure this version and class has it ?

thank you.

[eduardosuruagy]

I'm also using this version.

UniDBGrid.FullExpand; 

 

UniDBGrid.FullCollapse;

[Freeman35]

So strange,

[dcc32 Error] ufrm.pas(133): E2003 Undeclared identifier: 'FullCollapse'

And search in unigui, only TreeGrid and TreeView has this procedure.

[eduardosuruagy]

sorry, I'm actually using UniDBTreeGrid

[Sherzod]

On 11/5/2018 at 6:42 PM, Freeman35 said:

I wanna after open dataset, Collaps all group

Hello,

One of the possible solution I think

1. CustomCSS:

.x-grid-group-hd-collapsed .x-grid-group-title {
    background-image: none;
}

2. UniDBGrid1 -> OnAfterLoad event:

procedure TMainForm.UniDBGrid1AfterLoad(Sender: TUniDBGrid);
begin
  UniDBGrid1.JSInterface.JSCall('view.features[0].collapseAll', []);
end;

 

[Freeman35]

Thank you so much,

I didn't understand css, why need thats? its work without add that.

Regards.

[fraxzi]

Hi @Sherzod,

How to expand the first group?

Thanks,

Frances

[Sherzod]

3 minutes ago, fraxzi said:

How to expand the first group?

Hello,

What are your grid settings?

[fraxzi]

2 hours ago, Sherzod said:

Hello,

What are your grid settings?

Hi,

dbgrid-> grouping -> collapsible, summary -> grandtotal

Just normal dbgrid with grouping and summary.

Thanks,

Frances

[Sherzod]

2 minutes ago, fraxzi said:

dbgrid-> grouping -> collapsible, summary -> grandtotal

Just normal dbgrid with grouping and summary.

Options -> dgEditing = ?

[Sherzod]

2 hours ago, fraxzi said:

How to expand the first group?

Isn't everything expanded by default?

[fraxzi]

47 minutes ago, Sherzod said:

Isn't everything expanded by default?

Hi,

Yes all expanded.. I copied the code above to collapsed and it did.

i just want to expand the first group by code.

 

[Sherzod]

1 hour ago, fraxzi said:

i just want to expand the first group by code.

Okay, you can try to use this approach:

1. UniDBGrid1.ClientEvents.UniEvents ->

function afterCreate(sender) 
{
    sender.expandFirstGroup = function() {
        try {
            sender.getView().features[0].expand(sender.getView().features[0].dataSource.data.items[0].groupKey)
        } catch (err) {}
    }
}

2. Usage:

procedure TMainForm.UniButton1Click(Sender: TObject);
begin
  UniDBGrid1.JSInterface.JSCall('expandFirstGroup', []);
end;

 

[fraxzi]

On 9/29/2023 at 2:56 PM, Sherzod said:

Okay, you can try to use this approach:

1. UniDBGrid1.ClientEvents.UniEvents ->

function afterCreate(sender) 
{
    sender.expandFirstGroup = function() {
        try {
            sender.getView().features[0].expand(sender.getView().features[0].dataSource.data.items[0].groupKey)
        } catch (err) {}
    }
}

2. Usage:

procedure TMainForm.UniButton1Click(Sender: TObject);
begin
  UniDBGrid1.JSInterface.JSCall('expandFirstGroup', []);
end;

 

Yes!!! @Sherzod, works like a charm!  Thanks much..