Scroll

Global Event: OnParameterSqlStatementConstructed

Called after a parameter dropdown object is constructed. Allows for modifying the object SQL.

Signature     

For custom code the args array is structured as follows:

args[] contains one object, the SQL string which is passed to the server to construct the parameter dropdown.

For .Net Assemblies the method signature is as follows:

string EventHandlerName(SessionInfo sessionInfo, string sqlStatement)

Expected Return

The event expects a string return value: The (modified) SQL statement to be passed to the server to construct the parameter dropdown.

Example

// Orders dropdowns as descending
string sql = args[0].ToString();
return sql.Replace("asc", "desc");

Hidden Article Information

Article Author
Exago Development
created 2017-02-21 16:14:02 UTC
updated 2017-06-27 14:40:51 UTC

Labels
Server Events, parameters, event handlers, list of server events, parameter, parametersqlstatementconstructed, sqlstatement, stmt, statement, constructed, sql,
Have more questions? Submit a request