Jump to content


Photo

DBGrid Clientside Sorting


  • Please log in to reply
13 replies to this topic

#1 mohammad

mohammad

    Advanced Member

  • uniGUI Subscriber
  • PipPipPipPip
  • 705 posts
  • LocationKufur Kassem, Palestine

Posted 20 January 2016 - 05:19 PM

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):

 

s1.png

 

 

 

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

 

s2.png

 

 

Hope this will help you :-)

 


  • 4

#2 Abaksoft

Abaksoft

    Advanced Member

  • uniGUI Subscriber
  • PipPipPipPip
  • 510 posts
  • LocationAlgeria

Posted 21 January 2016 - 08:41 PM

Thx Mohammad
I will test it...
Greetings
  • 0

#3 BYGraham

BYGraham

    Newbie

  • uniGUI Subscriber
  • Pip
  • 2 posts

Posted 26 January 2017 - 09:58 PM

Works beautifully, nice and fast. Thx!


  • 0

#4 lcolombo

lcolombo

    Member

  • uniGUI Subscriber
  • PipPip
  • 15 posts

Posted 17 July 2017 - 10:16 PM

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,


  • 0

#5 Delphi Developer

Delphi Developer

    Advanced Member

  • Moderators
  • 3887 posts

Posted 18 July 2017 - 06:32 AM

Hi,

 

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

 

Attached File  ExtDataStore.png   10.81KB   11 downloads

 

Best regards,


  • 0

#6 lcolombo

lcolombo

    Member

  • uniGUI Subscriber
  • PipPip
  • 15 posts

Posted 18 July 2017 - 02:01 PM

Thank you very much.

I was looking at ExtEvents and was in UniEvents

 

Regards,


  • 0

#7 alp.yilmaz

alp.yilmaz

    Member

  • uniGUI Subscriber
  • PipPip
  • 42 posts
  • LocationAdana

Posted 22 September 2017 - 11:35 AM

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..


  • 0

#8 M477H13U

M477H13U

    Active Member

  • uniGUI Subscriber
  • PipPipPip
  • 53 posts

Posted 10 October 2017 - 08:31 AM

Hello there !! (:

 

It works perfectly, but what about multiColumnSorting ? :3


  • 0

M477h13U,

 

UniGUIVersion: 1.0.0.1424.


#9 delagoutte

delagoutte

    Advanced Member

  • uniGUI Subscriber
  • PipPipPipPip
  • 306 posts

Posted 10 October 2017 - 09:21 AM

M477H13U

try add in beforeinit :

config.multiColumnSort = true;


  • 0

#10 M477H13U

M477H13U

    Active Member

  • uniGUI Subscriber
  • PipPipPip
  • 53 posts

Posted 10 October 2017 - 09:34 AM

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  ^_^


  • 0

M477h13U,

 

UniGUIVersion: 1.0.0.1424.


#11 jinhu

jinhu

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 03 January 2018 - 12:33 PM

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


  • 0

#12 Delphi Developer

Delphi Developer

    Advanced Member

  • Moderators
  • 3887 posts

Posted 03 January 2018 - 03:29 PM

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,


  • 0

#13 MOGSY

MOGSY

    Newbie

  • uniGUI Subscriber
  • Pip
  • 8 posts

Posted 08 January 2018 - 04:11 AM

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


  • 0

#14 Delphi Developer

Delphi Developer

    Advanced Member

  • Moderators
  • 3887 posts

Posted 08 January 2018 - 04:28 AM

Hi,

 

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

 

Best regards,


  • 0




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users