find button which shows data present in dhtmlxgrid

Discontinued products Uncategorized discussions
#1

i want to add functionality given in this link on my jsp page link is

dhtmlx.com/docs/products/docsExp … dhtmlxgrid







i do not want to attach header for each column.i just want a single textbox in which i write search criteria which displays results find in that dhtmlxgrid.







Please suggest me!!!it’s urgent

#2

You can use filterBy API instead of in-header filters



#3


which js is to be included for that?i got error object expected



 



Please response

#4

the code you have given is working on specific column…but i dont need to pass column.the search criteria can be in any column or row…
Please suggest me appropriate solution for that.

#5

The filterBy can be used for multiple columns, but this command will use AND logic for search queries, not OR. So it not possible to filter rows where searched value exists at least in one of columns
Technically complex workaround can be used, by findRows methods, which not filter grid, but returns an array of cells which match search criteria, which can be used with custom filtering function - it pretty complicated approach.

#6

how can be filter use for multiple column.Please let me know…



reply!!

#7

You can use
grid.filteBy([0,1,2].[“a”,“b”,“c”]);
First parameter an array of column indexes, the second is an array of filtering criteria

#8

hi i’m using
mygrid.filterBy([0,1,2,3,4,5,6,7,8],[document.getElementById(‘filter’).value]);

but it gives error!!!
Please suggest solution for that

#9

The count of values in first and second array must be equal
var val = document.getElementById(‘filter’).value;
mygrid.filterBy([0,1,2,3,4,5,6,7,8],[val,val,val,val,val,val,val,val,val]);

#10


i used



var a=document.getElementById(‘filter’).value;



createGrid.filterBy([0,1,2,3,4,5],[a,a,a,a,a,a]);



 



but it’s not working…it doesn’t show search result



 



Please help me!!

#11

As it was mentioned earlier
>>The filterBy can be used for multiple columns, but this command will use AND logic for search queries

createGrid.filterBy([0,1,2,3,4,5],[a,a,a,a,a,a]);

means
where column0 LIKE "%a%"AND column1 LIKE "%a%"AND column2 LIKE "%a%"AND column3 LIKE "%a%"AND column4 LIKE "%a%"AND column5 LIKE “%a%”