FilterChanged Event

Official Content
This documentation is valid for:

This event is triggered every time that values are removed from or added to the list of possible values for an attribute, whether it’s located in the rows, columns or pages area.


&FilterChangedData.{ Name | SelectedValues }

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

  • Name. Name of the element to which filters have been set.
  • SelectedValues. A list of values with the values that were selected.

QueryViewerFilterChangedData SDT Composition

QueryViewerFilterChangedData SDT


In this example, every time that some of the filters in the ClientActive QueryElement are changed, only the selected ones will be counted. ClientActive can only have Y, N, and both values. The TOTAL option of the filter will not be considered.

Event QueryClients.FilterChanged
    if &FilterChangedData.Name = 'ClientActive'
       for &TheClient in &LoadDataClientsSDT
           if &TheClient.ClientActive = &FilterChangedData.SelectedValues.CurrentItem
               &Amount += &TheClient.ClientAmount

Since the QueryClients.ChangedData event returns the collection of all the selected filters, the SDT path includes checking whether the client has the same value in ClientActive and in SelectedValues.CurrentItem.

The &Col (Collection) and &Value variables are of character type, matching the item data type of the SelectedValues collection of the SDT (see image that shows how it is composed) to run it through with the For command.


Output type: Table, PivotTable

See Also

Filter Changed Data property