Exago Logo
Generic filters
Exact matches only

Global Event: OnFilterSqlStatementConstructed

The OnFilterSqlStatementConstructed Event occurs just before SQL is sent to the Data Source to retrieve data to populate a filter dropdown. This Event could be used to inspect, log or modify the SQL that is being used to populate the dropdown.


For custom code the arguments array is structured as follows:

args[] contains:

  1. a string representing the filter SQL

For .NET Assemblies the method signature is as follows:


Include the WebReports.Api.Data namespace.

string EventHandlerName(SessionInfo sessionInfo, string filtersSql, SqlObject sqlObject)

Expected Return

The OnFilterSqlStatementConstructed Event expects a string value to be returned.


This Event will provide the SQL for the Filter Dropdown Object if that feature is being utilized. See Data Objects for more information on Filter Dropdown Objects.

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Table of Contents