jQuery UI Widgets Forums Grid Grid paging, sorting from XML datasource

Tagged: , , ,

This topic contains 0 replies, has 1 voice, and was last updated by  Gopre400 9 years, 12 months ago.

Viewing 1 post (of 1 total)
  • Author

  • Gopre400
    Participant

    Hi I create a SQL query and user .ajax call to WebService which returns data in XML format. However the grid with paging does not sort in the same order as the query. Is this the behavior I should expect? Is there a work-around to sort a grid with paging?

    here is source of Grid…
    datafields: [
    { name: ‘SignID’ },
    { name: ‘District’, type: ‘int’ },
    { name: ‘ActivityCode’, type: ‘int’ },
    { name: ‘SignQuantity’, type: ‘int’},
    { name: ‘SignText’, type: ‘string’ },
    { name: ‘SignNote’ },
    { name: ‘SignSize’ },
    { name: ‘RequestedBy’ },
    { name: ‘RequestedDate2’ },
    { name: ‘RequestID’ },
    { name: ‘RFI’ },
    ],
    async: false,
    record: ‘Table’,
    url: ‘SRQWebService.asmx/GetSRQViewStreetPlatesGrid’,
    sortcolumn: ‘RFI’,
    sortdirection: ‘dsc’,
    pagesize: 20

    And here is grid…
    $(“#jqxgrid”).jqxGrid(
    {
    width: ‘100%’,
    source: dataAdapter,
    theme: ‘darkblue’,
    autoheight: true,
    sortable: true,
    altrows: true,
    enabletooltips: true,
    pageable: true,
    showstatusbar: true,
    editable: true,
    groupsrenderer: groupsrenderer,
    groupable: true,
    groupsexpandedbydefault: true,
    closeablegroups: false,
    editmode: ‘click’,
    selectionmode: ‘singlerow’,
    ready: function () {
    $(“#jqxgrid”).jqxGrid(‘expandallgroups’);
    $(‘#jqxgrid’).jqxGrid(‘gotopage’, gridpagenum);
    },

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.