ItemCollapse Event

Official Content
This documentation is valid for:

It allows programming actions when the user collapses a QueryElement with nested data, hiding its values.


&ItemCollapseData.{ ExpandedValues | Name | Value }

When the event is triggered, its parameters are queried in the "ItemCollapseData" property. It returns an SDT with the following data:

  • Name. Name of the element that was collapsed.
  • ExpandedValues. These are the values of the element indicated in Name that remain expanded.
  • Value. The value contained in the collapsed cell.


In this example, when an investor's row is collapsed in the ClientId QueryElement, its amount must be taken into account in the total represented in the WebLinearGauge control. Therefore, when the Collapse action is performed, the client is searched for in the LoadDataClientsSDT –this SDT was loaded in the Start event–, the amount is subtracted from the total and sent to the WebLinearGauge control.

The &ItemCollapseData variable is based on the QueryViewerItemCollapseData SDT.

Event QueryClients.ItemCollapse
    If &ItemCollapseData.Name = 'ClientId'
       for &TheClient in &LoadDataClientsSDT
           &ClientId = Val(&ItemCollapseData.Value)
           if &TheClient.ClientId = &ClientId
              &Amount = &TheClient.ClientAmount
      &GaugeSDT.Value = &UCLinear - &Amount


Chart type: PivotTable


See Also

ItemExpand Event
Item Collapse Data property