ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: hellokert on June 08, 2017, 12:54:37 am

Title: column > filter > type=select order problem
Post by: hellokert 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...

Title: Re: column > filter > type=select order problem
Post by: paramvir 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

Title: Re: column > filter > type=select order problem
Post by: hellokert on June 08, 2017, 03:34:57 pm

Great Thanks!

The ignoreCase: true option is OK for both problem.

Very Thank you!