Custom Filter in grid

Discontinued products Uncategorized discussions
#1

I have a grid where I am displaying a small icon in a column. I need to be able to filter on the image in column 4 (index 3) so have created my own select box in the grid header along with the following JS to filter the column:



function statusSort(pFilterValue){

    

    objsurveyList.filterBy(3,pFilterValue);

    

}



The only thing I can think of is perhaps the values I am using for filtering need to be escaped? Or perhaps it is matching on the text rather than the value? Guidance would be greatly appreciated.



Grid XML (initialization and two rows worth of data) is as follows:













/js/dhtmlxsuite/dhtmlxGrid/codebase/imgs/







#master_checkbox,#select_filter,#text_filter,

ClosedOpen
,#select_filter







tpmg







Group

Survey

Status

Due

Receving

Total Surveys

Done (%)



Center







0

First Test Group



Test ii









9 Feb 2009

1

1

100%

2009-02-09 00:00:00

ELE







0

First Test Group



Leadership









11 Feb 2009

1

0

0%

2009-02-11 00:00:00

ELE

#2

You shouldn’t escape values using for filtering. Grid will take “getValue()” from the cell and will search passed value in it. So if you have “Test ii” in the cell, getValue() method returns string “Test ii”. If you need to be able to make search only by actual value (Test ii), getValue() method should return only necessary value. It can be done using custom eXcell type or by implementing custom filtering rule.
Please see more information here dhtmlx.com/docs/products/dhtmlxG … grid_fsing