Author Topic: column > filter > type=select order problem  (Read 2192 times)

hellokert

  • Pro Deluxe
  • Newbie
  • *
  • Posts: 15
  • Hellokert
    • View Profile
column > filter > type=select order problem
« on: June 08, 2017, 12:54:37 am »
Dear Support!

I'm a hungarian man. I use "utf8_hungarian_ci" code in database and in applications.

The order is in the grid select combo: (example)
Magyar József
Marosi Katalin
Nádori Géza
Pap Zoltán
Postás Ferenc
kis aliz
magyar péter
Örs Gábor
Új Tamás

so the first character M,M,N,P,P,k,m,Ö,Ú

The order is in normal select combo: (example)
kis aliz
Magyar József
magyar péter
Marosi Katalin
Nádori Géza
Örs Gábor
Pap Zoltán
Postás Ferenc
Új Tamás

so the first character k,M,m,M,N,Ö,P,P,Ú

This is right by hungarian alphabet.

I could not find a solution in the methods. Is there a solution to this?
(Look at the attachment as well!)
Thank you...

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: column > filter > type=select order problem
« Reply #1 on: June 08, 2017, 10:41:15 am »
I need to know how have you assigned the options in the select list.

If the options are filled by getData method, then setting sortModel.ignoreCase: true would help.

https://paramquery.com/pro/api#option-sortModel
« Last Edit: June 08, 2017, 10:44:45 am by paramquery »

hellokert

  • Pro Deluxe
  • Newbie
  • *
  • Posts: 15
  • Hellokert
    • View Profile
Re: column > filter > type=select order problem
« Reply #2 on: June 08, 2017, 03:34:57 pm »
Great Thanks!

The ignoreCase: true option is OK for both problem.

Very Thank you!