[zokanziParticipant]

Thanks ivalio. I have to look this demo more carefully.

[zokanziParticipant]

I looked at the demo. But I couldn’t work it. Maybe it is too complex for me. Is not there a simpler solution for this simple problem like this?

text: 'Color', filtertype: 'list', filteritems: [value: '1', label: 'blue', value: '2', label:'red', value: '3', label: 'yellow'], datafield: 'Color', width: "6%"

Thanks…

[zokanziParticipant]

Hi @richardjansen;

Can you share me sample codes if possible.

Thanks…

[zokanziParticipant]

Hi all. I don’t solve this problem. Which variable get total record value on data page. Can I determine total record count after filtering? If yes, which variable can I use?

Help me please… Thanks…

[zokanziParticipant]

<%=Total%> is record count at table.

I tried many methods like

beforeprocessing: function (data) {
    source.totalrecords = data.Total;
},

All methods show count of records on current page. I want show all record count at table when page load first. Then it shows current appropriate record count when type filter. Ex: All record count in table: 3750, Record count on a page: 20, Rocord count when type EVRA: 20 (It must be 32).

Please help. Thanks…

[zokanziParticipant]

Hi Peter;

I am sorry. I didn’t know what you don’t work weekend.

All system works fine this link

I define total count with asp code:

beforeprocessing: function (data) {
    source.totalrecords = <%=Total%>;
    }

If I don’t define, code doesn’t worked. Where is my fault?

[zokanziParticipant]

Why are you answer my question positive or negative? Is it impossible? Or easy. Please answer me…

[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.

[zokanziParticipant]

I found what i want in this link. But i don’t know how to do. Total count updating table while filtering.

[zokanziParticipant]

@onurkaya this is very clear sample. Thanks… But I need filtering and sorting asp codes. If you have, can you share to me? (with respect from Kırsehir)

[Author]

Posts