Grid with multiple sources and server paging

[oeriksenParticipant]

I have a grid which is filled from one of three different sources depending on a dropdownlist. The three different sources have different datafields and different url (which is changing depending on the dropdownlist). And I’m using server paging. Everything is working fine except when changing sources the grid stays on the same page. It doesn’t reset to page 1. So if I’m on page 3 on sourceA and I’m changing to sourceB I’m getting page 3 on sourceB. This is annoying and a problem if the new source doesn’t have more than 1 page. Then I’m getting an empty grid and “0-0 of 0”. If I’m on page 1 and changes to a source with only 1 page it’s working fine. I have a function which is executed when the dropdownlist changes:

function fillItem(catId, catType) {
  if (catId == lastCatId) return;
  var dataAdapter;
  switch (catType) {
    case 1:
      itemCurrentColumns = trackColumns;
      trackSource.url = trackBaseUrl+catId;
      dataAdapter = new $.jqx.dataAdapter(trackSource);
      itemGrid.jqxGrid({ columns: trackColumns });
      break;
    case 2:
    case 4:
      itemCurrentColumns = miscsndColumns;
      miscsndSource.url = miscsndBaseUrl+catId;
      dataAdapter = new $.jqx.dataAdapter(miscsndSource);
      itemGrid.jqxGrid({ columns: miscsndColumns });
      break;
    case 3:
      itemCurrentColumns = commColumns;
      commSource.url = commBaseUrl+catId;
      dataAdapter = new $.jqx.dataAdapter(commSource);
      itemGrid.jqxGrid({ columns: commColumns });
      break;
    default:
      return;
  }
  itemGrid.jqxGrid({ source: dataAdapter });
  lastCatId = catId;
}

I’ve been looking a lot on the examples and tried a lot of things (including setting page 1 manually) but I can’t figure it out.
Anyone has an idea?

I’m using version 3.7.0 btw. I saw another post with basically the same question and there it was asked which version they where using.

[Peter StoevKeymaster]

Hi oeriksen,

You can use “gotopage” method to change the current page before you apply new source.

Best Regards,
Peter Stoev

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

[oeriksenParticipant]

Hi Peter.

That does not always work, at least not with async sources. Sometimes I end up with sourceA rows (from page 1) instead of sourceB rows. I guess async=false will solve it but then dropdownlist freezes while data is loading.

And you end up with an extra server fetch (page 1 on sourceA before sourceB). That’s not a big deal but I don’t like it.

Best regards,
Oyvind Eriksen

[oeriksenParticipant]

I made a workaround which seems to work fine. I created a “dummy” source from a local array with a single row (with empty values). When changing sources I first set the grid source to the dummy source. This reset the page number. Then I set the grid source to the new source and everything is fine. It’s a hack but a pretty smooth hack if I can say so myself Visually you don’t see anything but a normal grid change.

[Author]

Posts