How to get JQGrid record count after filtering?

[zokanziParticipant]

I am using JQGrid server-side for about 4000 record count data table in this link

I can get total row count (3952 record). But I can’t get count after filtering (ex: writing “EVRA” to Adi column. Total count must be “2” but it does not change).

My codes:

 $(document).ready(function () {
        // prepare the data
        var theme = 'energyblue';
        var customsortfunc = function (column, direction) {
            var sortdata = new Array();
            if (direction == 'ascending') direction = true;
            if (direction == 'descending') direction = true;
            if (direction != null) {
                for (i = 0; i < data.length; i++) {
                    sortdata.push(data[i]);
                }
            }
            else sortdata = data;
            var tmpToString = Object.prototype.toString;
            Object.prototype.toString = (typeof column == "function") ? column : function () { return this[column] };
            if (direction != null) {
                sortdata.sort(compare);
                if (!direction) {
                    sortdata.reverse();
                }
            }
            source.localdata = sortdata;
            $("#jqxgrid").jqxGrid('updatebounddata', 'sort');
            Object.prototype.toString = tmpToString;
        }
        // custom comparer.
        var compare = function (value1, value2) {
            value1 = String(value1).toLowerCase();
            value2 = String(value2).toLowerCase();
            try {
                var tmpvalue1 = parseFloat(value1);
                if (isNaN(tmpvalue1)) {
                    if (value1 < value2) { return -1; }
                    if (value1 > value2) { return 1; }
                }
                else {
                    var tmpvalue2 = parseFloat(value2);
                    if (tmpvalue1 < tmpvalue2) { return -1; }
                    if (tmpvalue1 > tmpvalue2) { return 1; }
                }
            }
            catch (error) {
                var er = error;
            }
            return 0;
        };
        var source =
        {
            datatype: "json",
            datafields: [
                 { name: 'ID', type: 'number' },
                 { name: 'Adi', type: 'string' },
                 { name: 'Adres', type: 'string' }                
                 ],

            url: 'working_load.asp',

            root: 'Rows',
            sortdatafield: 'Adi',
            sortorder: 'asc',
            filter: function(){
            // Update the grid and send a request to the server.
            $("#jqxgrid").jqxGrid('updatebounddata', 'filter');
            },
            sort: function(){
            // Update the grid and send a request to the server.
            $("#jqxgrid").jqxGrid('updatebounddata', 'sort');
            },
            beforeprocessing: function (data) {

                **source.totalrecords = <%=Total%>;**
            }
        };

        var dataadapter = new $.jqx.dataAdapter(source);
        // initialize jqxGrid
        $("#jqxgrid").jqxGrid(
        {
            width: "100%",
            localization: getLocalization('de'),
            theme: 'energyblue',
            source: dataadapter,
            autoheight: true,
            pageable: true,
            virtualmode: true,
            columnsreorder: true,
            sortable: true,
            columnsresize: true,
            filterable: 'simple',
            showfilterrow: true,
            altrows: true,
            pagesize: 20,
            pagesizeoptions: [10,20,40,100,500],
            selectionmode: 'singlerow',
            rendergridrows: function () {
                return dataadapter.records;
            },

            columns: [
                  { text: 'Kodu', datafield: 'Kodu', width: "8%" },
                  { text: 'Adi', datafield: 'Adi', width: "20%" },
                  { text: 'Adres', datafield: 'Adres', width: "15%" }                  
                  ]
        });

});     

<%=total%> variable is obtained from asp code and it is shown total count. But i want getting count after filtering. Maybe it has very simple solution, but I have not found solution despite searching for this problem.

Thanks for your helps…

[zokanziParticipant]

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

[zokanziParticipant]

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

[Peter StoevKeymaster]

Hi zokanzi,

“Why are you answer my question positive or negative? ” – Nobody answered any question asked by you till Now. You’re new User with 2 Topics asked during the Weekend when there is nobody in the Office.

We have demos and help tutorials which show how to implement Server Filtering. One such demo is: http://www.jqwidgets.com/jquery-widgets-demo/demos/php/serverfiltering.htm?arctic. Total Rows Count is updated after Filtering.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

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

[Peter StoevKeymaster]

Hi zokanzi,

I don’t know what is < %=Total@> in your code. We have demos & tutorials. Follow them to achieve the desired results.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

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

[Peter StoevKeymaster]

Hi zokanzi,

data.Total then it not 3750 but something else. I suggest you to look at our Help Tutorials and Online demos to learn how to implement this both Client & Server side.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

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

[Author]

Posts