Newbie need help!!!

[choncona1]

I know this is a newbie's question, but I am really bumping my head with it.
I have a page with the button that will load data to a grid.
The grid's columns are sortable. The data is ordered from database.
From the UI, clients are able to sort data by themselves.
Now, the requirements is that every time clicking the upper "refresh" button
it shall reload the data with the order from database.
But it seems doesn't work out for me since it keeps the remain sorting order from the UI.
This is my method to solve the problem

listeners: {
click: function() { 
storeEG.load();
Ext.getCmp('tempField').removeAll(true);
Ext.getCmp('tempField').add(new Ext.grid.GridPanel({
id: 'display',
store: storeEG,
cm: colModel
}));                    
resizing();                    
Ext.getCmp('tempField').doLayout();
}
}

If you have any problems reading my code, please let me know.
I simply create a 'fielset', then removing everything before reloading.
Please spend kindly assist me with this problem.
Thank you very much

[Condor]

I assume that your store is not configured with remoteSort:true?

In that case you simply need to remove the sortInfo (or multiSortInfo), e.g.

delete store.sortInfo;
store.load();

[choncona1]

I assume that your store is not configured with remoteSort:true?

In that case you simply need to remove the sortInfo (or multiSortInfo), e.g.

delete store.sortInfo;
store.load();

hi, Condor
Thank you for your quick reply,
I haven't tried to remove the sortInfo
but I configured the remoteSort:true as you had mentioned
the result from that is when the client sort manually,it doesn't turn out as the normal way
Would you mind giving me a short explanation on how does this work out?
I am really appreciated for your time.

[Condor]

A store has 2 sort modes, local and remote.

1. In local mode the store uses the sortInfo (or multiSortInfo) to sort the data itself.
2. In remote mode the store sends 'sort' and 'dir' parameters with the load and expects the server to return the records in the correct order.

It looks like you want local mode (remoteSort:false), but you want to remove the sortInfo before loading.

[choncona1]

thanks,
Just another question, is there anything like "store.sortInfo.remove"?
I am finding it for a while but couldn't get any hints.

[Condor]

Didn't you look at post #2?

[choncona1]

sorry, my bad
but even i tried something like below as in my code

delete storeEG.sortInfo;
storeEG.load();

the refreshed-again-result still doesn't come out as same as database after the manual sorting
sorry for my bad English if it sound vague

[Condor]

1. Is storeEg a normal Store or a GroupingStore?
2. Is your server sending metaData with sortInfo together with the data?

[choncona1]

1/It is the normal store. this is how i wrote the store

var storeEG=new Ext.data.Store({
proxy: new Ext.data.HttpProxy({ method: 'post',url: 'rPages/rEgsitting.aspx?m=egcomb' })        
,reader: gridJson
});

2/Not really sure about the term "metaData", but the sortInfo does come together with the data since the store procedure
from DB write "ORDER BY..."

[Condor]

If you don't know what metaData is then you are definately not using it.

Strange... In that case this should really work:

delete storeEG.sortInfo;
delete storeEG.multiSortInfo;
storeEG.load();