Link Search Menu Expand Document

Custom Functions

If you have CustomJS enabled you can add custom functions to be available in the SQL queries. The example below uses the class found in [[customjs/custom-functions.js]]. To reference a function in your query you need to add a directive to the code block telling it what functions to make available. It will then register the CustomJS function in the referenced class.

The format of the directive is: #customjs ClassName FunctionName

The example below uses this class registered in CustomJS

class MyTaskFunctions {
    SuperImportant(status) {
        return status.indicator === '!';
    }
}

It is then made available in the query via the #customjs directive specifying the class name and then the function name. It is #customjs MyTaskFunctions SuperImportant for this example.

When called from the query the status object is passed to the function as a property allowing the function to return true if the indicator value is equal to !

 WHERE SuperImportant(status)
 #customjs MyTaskFunctions SuperImportant
WHERE SuperImportant(status)
#customjs MyTaskFunctions SuperImportant