Can I add custom rules/operators to querybuilder?

Webix JS
#1

I am evaluating webix and am trying to replace some existing code with it. I want to use the querybuilder component in my report builder. I would like to replace the existing functionality, but there are some rules in my existing code that do not appear in the querybuilder. Specifically, ‘like’ and ‘not like’ which are SQL ‘LIKE’ and ‘NOT LIKE’ operators. Also, a ‘has pattern’ rule that expects a regular expression as the value.

#2

Hello,

You can apply the setFilters method to define the new set of filters for Query Builder.

Please note that for this method you will need to provide the full array of filters, built-in and custom ones. Also, you will need to define a localization string for your filter:

webix.i18n.querybuilder.test = "My Test Filter";
$$("querybuilder").setFilters([
   {   
      id: "test", 
      name: "test", 
      fn(a, b){ return a === b; },  
      type: "any"
    },
    ... //full list
]);

Here’s the snippet: https://snippet.webix.com/aoo521br

#3

Excellent! Thanks!