DBGrid Clientside Sorting

[mhmda]

Hi,

 

As default behavior of dbgrid is performing sorting in server side, but sometimes you fetch all data into grid (no paging) and the data is already in client, so why return to server to sort data !!

 

Do the sort in client side:

 

1. Disable remoteSort (store):

 

 

 

 

2. Set 'click' event on column header and do sorting:

 

 

 

Hope this will help you :-)

 

[Abaksoft]

Thx Mohammad

I will test it...

Greetings

[BYGraham]

Works beautifully, nice and fast. Thx!

[lcolombo]

I do not have the event Ext.data.Store  -> store.afterCreate

 

I tried to put the event Ext.grid.Panle -> headerclick but it did not work. any ideas?

 

Regards,

[Sherzod]

Hi,

 

I do not have the event Ext.data.Store  -> store.afterCreate

 

 

Best regards,

[lcolombo]

Thank you very much.

I was looking at ExtEvents and was in UniEvents

 

Regards,

[alp.yilmaz]

Thank you...
How to sort all the data in the grid.
This process only sees the page you are on ..

 

teşekkürler...
Grid içerisindeki Tüm dataları nasıl sıralarız.
Bu İşlem Sadece Bulunduğu Sayfayı Sıralıyor..

[M477H13U]

Hello there !! (:

 

It works perfectly, but what about multiColumnSorting ? :3

[delagoutte]

M477H13U

try add in beforeinit :

config.multiColumnSort = true;

[M477H13U]

Super !!

 

it works just fine ! (:

 

Thank you very much delagoutte 

 

nb: My manager don't like Js, so I might use this solution in last resort, I'm going to answer to your other post 

[jinhu]

hi, I tried your code, but not successful. what is frmcaseview?do i need to change something with my dlphi component's  name?

[Sherzod]

Hi,

 

hi, I tried your code, but not successful. what is frmcaseview?do i need to change something with my dlphi component's  name?

 

Which edition and build are you using ?!

 

Best regards,

[MOGSY]

 I am using version 1 and the Store events are different, what version Mohammad is using?

[Sherzod]

Hi,

 

Which build are you using, and what is your problem ?!

 

Best regards,

[eduardosuruagy]

I have a problem in dbgrid, when I click on the column to sort LoadMask appears at the time of the click but it does not undo, with the screen stuck and the column does not sort. I'm using the option of our friend Mohammad.

 

function headerclick (ct, column, e, t, eOpts)

{

   Frame.dbgrid.getStore (). Sort (column.dataIndex);

}

 

function store.afterCreate (sender)

{

   sender.remoteSort = false;

}

[eduardosuruagy]

an anyone help?

[eduardosuruagy]

an anyone help?

[Sherzod]

Hi,

 

Try this:

function store.afterCreate(sender)
{
    sender.setRemoteSort(false);
}

[mhmda]

[M477H13U]

Hello there ! (:

 

You should try this out :

  UniSession.AddJS(UniDBGrid1.JSName+'.store.getSorters().add(new Ext.util.Sorter({property: 1,direction: "DESC"}));');

[eduardosuruagy]

 

Hi,

 

Try this:

function store.afterCreate(sender)
{
    sender.setRemoteSort(false);
}

 

Thank you, it worked.

[M477H13U]

Hello UniGUI users ! (:

I have a question concerning sorting..

at the moment, I cancel a specific sort like that:

  UniSession.AddJS(uniDBGrid1.JSName + '.getStore().sorters.remove('+IntToStr(UniDBGrid1.CurrCol)+');');
  UniSession.AddJS(UniDBGrid1.JSName+'.getView().refresh();');

If it's the only sort that was on the grid, the order of aggregats does not change. Then if I wants to apply the same sort on the same column, sorting is indeed visible on the interface, but event UniDBGrid1MultiColumnSort is not fired.. is this normal behavior ?

What can I do to force the fire of this event ? (We have our own logic so it is unfortunate if event is not fired..)

Regards,

[Sherzod]

Hi, 

? 

[M477H13U]

Hello Sherzod,

Yeah I know this post, and yes my config.multiColumnSort is set to true.

I think that this issue append when your datas are already sorted and that you sort request does not change it. In that case only, event multiColumnSort is not fired.

Can you reproduce ? if not, I will make a testCase tomorrow! (I already tested it in a minimalist project).

Regards,

 

[Sherzod]

Please make a simple testcase for better understanding, thanks