And Operator in Custom filter for search api is not working

tp007

I want to filter records based on Text value using search api. e.g. below I want to filter records which ends with 11 But it should not include chl-ccsp-011 . I have tried below query but it is not working. Please suggest me how can i achieve ?.

filterText = "((11$)) && ((^(.(?!chl-ccsp-011))*$))";

$("#" + tableId).DataTable().column(colNum).search(filterText, true, false);

Thanks,
Tushar Prajapati

colin

With regexes, you also need to define what it should include, as well as what it shouldn't. For example, would "chl-011" be matched, or "11", or "011"?

Colin

tp007

I have already set regrex to true in filters. Am i missing anything? I am not getting it.

kthorngren

You need to build the proper regex expression. Regex is going to try a literal match of &&. Checkout this SO thread about not operators. I would first use a site like https://regex101.com/ to build the regex expression. Once it works there try it with Datatables.

Another option is to create a search plugin. See this example.

Kevin