DHTMLXGrid - dropdown filter using "wildcards" ?

Discontinued products Uncategorized discussions
#1

Hi there,

is it possible to make a dropdown filter box in DHTMLXGrid to search with a kind of “wildcard” like “*” or “%” in the cell?

I mean like this:



dropdown filter with items “CAR”, “BUS”, “BIKE” …



By selecting one of those filter options, the cells would be filtered with a kind of “wildcard”, like for example selecting “CAR” would also filter the cell containing “MYCAR” or “CAR99” or “MYCAR99”



Thanks for your support!



#2

Built in #select_filter can’t work in such mode , but you can create custom control with such functionality


    CAR
    BUS
    BIKE


where 1 - index of column to which filter will be applied

#3

Hi,
thanks for your good and quick response.
This is working fine so far.
But is it also possible to “combine” two of those filters, which means that I select one item in dropdown filter column A and after that I select another item in dropdown filter column B. The filter of column B should only run on the before selected items of the filter in column A. Is this possible?



#4

Yes, it possible.
Code will be siimilar to next


…

…

function filter(){
    mygrid.filterBy(1,document.getElementById(‘selectA’));
    mygrid.filterBy(2,document.getElementById(‘selectB’),true);
}

The true as 3rd parameter of filterBy says that command must filter agains previously filtered set instead of filtering against original set.