Active Query Builder support area

How to add user-defined functions to completion lists of Expression editor and SQL Text editor?

Last modified:

Dashboard Knowledge Base

Handle the CustomizeFunctions event and add new functions in the following way:

   void expressionEditor1_CustomizeFunctions(Dictionary<string, AdvancedKeywordInfo> functions)
           "customfunction1", // dictionary key for hashing (lowercase!)
           new AdvancedKeywordInfo(
           // Function display name
           // Function template that will be inserted into the text editor cursor position. 
           // May contain %CURSOR% macro to specify new cursor position.
           // Function description (displayed in tooltips). Use \n character to split lines up.
        "CustomFunction1(param1, param2)\nFunction description.\nBla Bla..."

           new AdvancedKeywordInfo(
               "CustomFunction2(param1, param2)\nFunction description.\nBla Bla..."


This article was helpful for 1 person. Is this article helpful for you?