Server side filtering issue

[zokanziParticipant]

Hi all.
I am using server side filtering, sorting and paging jqxGrid in this link. It works very well for paging and sorting. But filtering works wrong. If I firstly select first column, and then typing 2nd column and then typing 3rd column, it works fine. But I firstly typing 3rd column, it filters first column.

I am getting this asp codes filter variables.

filterValue0 = Left((Request.QueryString("filtervalue0")),1)
filterValue1 = Request.QueryString("filtervalue1")
filterValue2 = Request.QueryString("filtervalue2")

My filtering codes:

filter: function(){
$("#jqxgrid").jqxGrid('updatebounddata', 'filter');
},

How should I take variables for working fine.

Thanks for your helps…

[zokanziParticipant]

I solve my problem myself.

filtervalue0 = Request.QueryString("filtervalue0")
filtervalue1 = Request.QueryString("filtervalue1")
filtervalue2 = Request.QueryString("filtervalue2")

filterdata0 = Request.QueryString("filterdatafield0")
filterdata1 = Request.QueryString("filterdatafield1")
filterdata2 = Request.QueryString("filterdatafield2")

SQL code:

SQL = "SELECT * FROM tbl WHERE Grup = 1 "
If Len(filtervalue0) <> 0 Then SQL = SQL + "AND "&filterdata0&" LIKE '%" + filterValue0 + "%'" 
If Len(filtervalue1) <> 0 Then SQL = SQL + "AND "&filterdata1&" LIKE '%" + filterValue1 + "%'" 
If Len(filtervalue2) <> 0 Then SQL = SQL + "AND "&filterdata2&" LIKE '%" + filterValue2 + "%'" 
SQL = SQL + " ORDER BY "&Sirala&" "&SiralaYon
SayfaRS.Open SQL, Conn

This is easy like this, but anybody helps me. Thanks anyway for people who read my question.

[Author]

Posts