Paging Toolbar Does Not Listen to sortInfo Config

[elshae]

Thanks for your reply, but it didn't work for me...

I tried:

placeNamesDataStore = new Ext.data.Store({
          id: 'placeNamesDataStore',
          proxy: new Ext.data.HttpProxy({
                    url: 'tibetTestAdmin.php',      // File to connect to
                    method: 'POST'
                }),
          baseParams: {task: "LISTING", sortInfo:{field: 'location', direction: "ASC"}},
....
....

I also tried:

baseParams: {task: "LISTING", field: 'location', direction:  "ASC"},

elshae

[darthwes]

baseParams: {
    task: "LISTING",
    sort: 'location',
    dir: 'ASC'
},
remoteSort: true,
sortInfo: {
    field: 'location',
    direction: "ASC"
},

[elshae]

I really appreciate the help, but it's not taking effect

placeNamesDataStore = new Ext.data.Store({
          id: 'placeNamesDataStore',
          proxy: new Ext.data.HttpProxy({
                    url: 'tibetTestAdmin.php',      // File to connect to
                    method: 'POST'
                }),
          baseParams: {task: "LISTING", sort: 'location', dir: 'ASC'}, // this parameter asks for listing
          reader: new Ext.data.JsonReader({   
                      // we tell the datastore where to get data from
            root: 'results',
            totalProperty: 'total',
            idProperty: 'place_names_id',
          
          fields: [
            {name: 'location', type: 'int', mapping: 'location'},
            {name: 'name', type: 'string', mapping: 'name'},
            {name: 'language_id', type: 'int', mapping: 'language_id'},
            {name: 'language', type: 'string', mapping: 'language'},
            {name: 'valid_name', type: 'string', mapping: 'valid_name'},
            {name: 'transliteration', type: 'string', mapping: 'transliteration'},
            {name: 'english_translation', type: 'string', mapping: 'english_translation'},
            {name: 'type', type: 'int', mapping: 'type'},
            {name: 'date_created', type: 'string', mapping: 'date_created'},
            {name: 'date_modified', type: 'string', mapping: 'date_modified'},
            {name: 'status', type: 'string', mapping: 'status'},
            {name: 'place_group', type: 'int', mapping: 'place_group'},
            {name: 'located_true', type: 'string', mapping: 'located_true'},
            {name: 'place_names_id', type: 'int', mapping: 'place_names_id'},
            {name: 'mslink', type: 'int', mapping: 'mslink'},
            {name: 'source', type: 'int', mapping: 'source'},
            {name: 'place_location_id', type: 'int', mapping: 'place_location_id'},
            {name: 'lat', type: 'float', mapping: 'lat'},
            {name: 'long', type: 'float', mapping: 'long'},
            {name: 'feature_code', type: 'string', mapping: 'feature_code'},
            {name: 'county', type: 'int', mapping: 'county'},
            {name: 'prefecture', type: 'int', mapping: 'prefecture'},
            {name: 'valid_location', type: 'string', mapping: 'valid_location'},
            {name: 'category', type: 'string', mapping: 'category'},
            {name: 'category_id', type: 'int', mapping: 'category_id'}
          ]}),
          remoteSort: true,
          sortInfo:{field: 'location', direction: "ASC"}
          
    });

Thank you,

elshae

[elshae]

I still have not yet resolved this

[johnathanhebert]

I think the problem is on your server side... can you confirm that you are sorting the records on the server?

[elshae]

I have decided to just do it straight from the query...

$query = "select * from (select * .......) as foo order by someField ASC ";

 // Add this for the paging bar:
     $start = (integer) (isset($_POST['start']) ? $_POST['start'] : $_GET['start']);
      $end = (integer) (isset($_POST['limit']) ? $_POST['limit'] : $_GET['limit']);
      $limit = $query." LIMIT ".$end." OFFSET ".$start;        
      $place_name_result = @pg_query($DBConnect, $limit);

Thanks everyone for pointing out to me to the server side, I know I'm not doing it the 'Ext' way, but I am satisfied with this...

cheers,

elshae

[johnathanhebert]

You are doing it the Ext way... when you set remoteSort:true, you told Ext that the server would do the sorting

[elshae]

interesting...I just tried remoteSort: false. It kinda works....What it does is sort the records of that page? So it seems that the paging happens first and then the sort and hence the undesirable results for me. When I tell the query to sort it, I can tell it before the paging? Is my understanding correct?

Thanks for your kind and continued help

elshae

[johnathanhebert]

Yes, your understanding is correct. Since the browser and Ext only have access to the records loaded in browser memory, they obviously cant be sorted against the records that are not loaded... that is exactly why there is a remoteSort config option, so that your server can do the sorting for all pages first on the server side, and then send back one page of those sorted results to the browser.

In your query, right after the "order by" field, you could use the passed "sort" request parameter to sort by whatever field was sent by the paging toolbar (and thus, the column header was clicked by the user or whatever)

[elshae]

Makes perfect sense to me now. Really, thank you so much!

I hope this post will help others on their journey..

cheers,

elshae