jQuery Grid Plugin - jqGridForum

Topic RSS

after reload the sort can't work well

28/05/2010
12:01

nanlinfeixue

Member

Members

Forum Posts: 7

Member Since:
28/05/2010

Offline

at first it can be work well

$("#InternetGrid").jqGrid({
        url: '/PopularFeelCollect/ChildPage/Internet.aspx',
        datatype: "json",
        height: 340,
        colNames: ['ç±»åˆ«', 'å…³é”®è¯', 'æœ€æ–°é‡‡é›†æ—¶é—´', 'é‡‡é›†æ•°é‡', 'åç³»ç»Ÿé‡‡é›†'],
        colModel: [
            { name: 'DataType', index: 'DataType', width: '15%', sortable: false, align: 'center' },
            { name: 'KeyWords', index: 'KeyWords', width: '50%', sortable: false, align: 'left' },
            { name: 'DoTime', index: 'DoTime', width: '20%', align: 'center'},
            { name: 'DataCount', index: 'DataCount', width: '15%', align: 'center', sorttype: 'int' },
            { name: 'SiteCount', index: 'SiteCount', width: '0%', hidden: true,sortable: false}
        ],
        jsonReader: {
            repeatitems: false
        },
        loadui: 'block',
        viewrecords: true,
        autowidth: true,
        pagerpos: 'center',
        rowNum: 20,
        rowList: [10, 20, 30],
        pgtext: "ç¬¬ {0} é¡µï¼å…± {1} é¡µ",
        recordtext: 'ç¬¬ {0} – {1} æ¡ å…± {2} æ¡',
        emptyrecords: 'æš‚æ— è®°å½•',
        pager: "#InternetPager",
        onPaging: function(which_button) {
            $("#InternetGrid").setGridParam({ datatype: 'json' });
        },
        loadError: function(xhr, status, error) {
            alert(xhr.responseText);
        },
        loadComplete: function() {
            $("#InternetGrid").setGridParam({ datatype: 'local' });
        }
    }).jqGrid('navGrid', '#InternetPager', { search: false, edit: false, add: false, del: false });

but after i call this Methods

$("#InternetGrid").setGridParam({ datatype: 'json', url: "/PopularFeelCollect/ChildPage/Internet.aspx?type=news", page: 1 }).trigger("reloadGrid");

click the é‡‡é›†æ•°é‡ to sort,i find it cann't sort by int.

but if i first click æœ€æ–°é‡‡é›†æ—¶é—´ then click the é‡‡é›†æ•°é‡ it will be working well.

the json data

{"total":"7","records":"123","page":"1","rows":[
{"Id":"136","DataType":"!!æœªåˆ†ç±»","KeyWords":"å‡¤å§","DoTime":"2010-05-28 16:47:29","DataCount":1119,"SiteCount":null},
{"Id":"135","DataType":"ç½‘ç»œåäºº","KeyWords":"æ›¾å“¥","DoTime":"2010-05-28 14:08:25","DataCount":910,"SiteCount":null},
{"Id":"134","DataType":"ç½‘ç»œåäºº","KeyWords":"æ˜¥å“¥","DoTime":"2010-05-28 14:07:31","DataCount":1175,"SiteCount":null},
{"Id":"133","DataType":"ç½‘ç»œåäºº","KeyWords":"çŠ€åˆ©å“¥","DoTime":"2010-05-28 14:08:06","DataCount":3195,"SiteCount":null},
{"Id":"132","DataType":"ç½‘ç»œåäºº","KeyWords":"åŠ›é‡ç”·","DoTime":"2010-05-28 14:06:50","DataCount":310,"SiteCount":null},
{"Id":"131","DataType":"ç½‘ç»œåäºº","KeyWords":"èŠ™è“‰å§å§","DoTime":"2010-05-28 11:16:59","DataCount":1356,"SiteCount":null},
{"Id":"129","DataType":"ç½‘ç»œåäºº","KeyWords":"æŽå®‡æ˜¥","DoTime":"2010-05-28 10:37:42","DataCount":2841,"SiteCount":null},
{"Id":"128","DataType":"ç½‘ç»œåäºº","KeyWords":"æ›¾è½¶å¯","DoTime":2010-05-28 11:38:52,"DataCount":0,"SiteCount":null},
{"Id":"127","DataType":"ç½‘ç»œåäºº","KeyWords":"æŠ½çƒŸç”·","DoTime":"2010-05-28 11:38:52","DataCount":1001,"SiteCount":null},
{"Id":"126","DataType":"ç½‘ç»œåäºº","KeyWords":"å…½å…½","DoTime":"2010-05-28 11:38:26","DataCount":1536,"SiteCount":null},
{"Id":"125","DataType":"ç½‘ç»œåäºº","KeyWords":"é—«å‡¤å¨‡","DoTime":"2010-05-28 11:37:57","DataCount":80,"SiteCount":null},
{"Id":"124","DataType":"ç½‘ç»œåäºº","KeyWords":"åŽèˆç”·ç”Ÿ","DoTime":"2010-05-28 11:37:30","DataCount":429,"SiteCount":null},
{"Id":"123","DataType":"ç½‘ç»œåäºº","KeyWords":"å°æ²ˆé˜³","DoTime":null,"DataCount":0,"SiteCount":null},
{"Id":"122","DataType":"ç½‘ç»œåäºº","KeyWords":"æ•™æŽˆ","DoTime":"2010-05-28 11:36:50","DataCount":921,"SiteCount":null},
{"Id":"121","DataType":"ç½‘ç»œåäºº","KeyWords":"åˆ˜è°¦","DoTime":"2010-05-28 11:35:22","DataCount":777,"SiteCount":null},
{"Id":"120","DataType":"ç½‘ç»œåäºº","KeyWords":"é™¶å®å¼€","DoTime":"2010-05-28 11:35:12","DataCount":775,"SiteCount":null},
{"Id":"119","DataType":"ç½‘ç»œåäºº","KeyWords":"ä¸‰å£ç¨»":"2010-05-28 11:33:57","DataCount":765,"SiteCount":null},
{"Id":"118","DataType":"ç½‘ç»œåäºº","KeyWords":"é£žå§é‡Žç‰›","DoTime":"2010-05-28 11:32:34","DataCount":765,"SiteCount":null},
{"Id":"117","DataType":"ç½‘ç»œåäºº","KeyWords":"å°èƒ–","DoTime":"2010-05-28 11:31:17","DataCount":1256,"SiteCount":null},
{"Id":"116","DataType":"ç½‘ç»œåäºº","KeyWords":"éžå¸¸çœŸäºº","DoTime":"2010-05-28 11:30:22","DataCount":760,"SiteCount":null}]}

30/05/2010
11:54

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

The sorttype: 'int' have sense only if you use local data (i.e array) I think the problem is in you server side code.

Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

31/05/2010
04:12

nanlinfeixue

Member

Members

Forum Posts: 7

Member Since:
28/05/2010

Offline

hello ,Tony

you see i set the datatype:local

loadComplete: function() {
$("#InternetGrid").setGridParam({ datatype: 'local' });
}

so i think is a bug

thanks

Best regards

jerry

01/06/2010
13:25

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

If you add

sortname: "Some valid from colmodel name"

you will not have a problem. The fix is in another position of the code.

Will try to test it.

Thanks.

Best Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

02/06/2010
04:53

nanlinfeixue

Member

Members

Forum Posts: 7

Member Since:
28/05/2010

Offline

hello ,

I added sortname: "DoTime",

Using the latest version 3.7 bata, all the columns can not be sort.

Using the version 3.6.5,the problem is still.

Thanks.

Best Regards

Jerry

02/06/2010
11:11

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

Your example work perfectly in my demo system.

The only change that I have mage is this:

        onPaging: function(which_button) {
            $("#InternetGrid").jqGrid('setGridParam',{ datatype: 'json' });
        },
        loadError: function(xhr, status, error) {

              alert(xhr.responseText);
        },
        loadComplete: function() {
            $("#InternetGrid").jqGrid('setGridParam',{ datatype: 'local' });
        }

Note how this is written

Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.