How to define data order as accent-insensitive?

[JMG74]

Hello, does anyone know how to define a FetchXML filter that sorts the data in an accent-insensitive way?
Because currently, the component lists our accented data (French) in an accent-sensitive order whereas in Dataverse the sorting lists the data in the expected accent-insensitive order.
Thank you in advance if any of you has any clue that could guide us to a solution. Best regards.

[NielsMinnee]

A fetchxml can include sorting. I don’t know by head if that is being applied in this control. Let me verify that later today. Message can be short, sent from my mobile Kind regards, met vriendelijke groet, Niels Minnee Mobile: +31 6 50 60 66 75<tel:+31%206%2050%2060%2066%2075> || <tel:+31%206%2050%2060%2066%2075> Office: +31 20 30 32 47 0 <tel:+31%2020%2030%2032%2047%200> [cid:frame14nowhitespace_9989cfb9-a06f-4680-8226-194f67b0bfdb.png] www.dynamicpeople.com <http://www.dynamicpeople.com/> || www.be-empowered.nl<http://www.be-empowered.nl/> || Schipluidenlaan 4 || 1062 HE || Amsterdam || The Netherlands The information contained in this communication is confidential and intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Dynamic People B.V. Dynamic People is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Dynamic People does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication, please return the communication to the sender and delete and destroy all copies.

…

________________________________ From: JMG74 ***@***.***> Sent: Thursday, April 20, 2023 6:33:10 PM To: NielsMinnee/NNDropdown ***@***.***> Cc: Subscribed ***@***.***> Subject: [NielsMinnee/NNDropdown] How to define data order as accent-insensitive? (Issue #16) External Email Hello, does anyone know how to define a FetchXML filter that sorts the data in an accent-insensitive way? Because currently, the component lists our accented data (French) in an accent-sensitive order whereas in Dataverse the sorting lists the data in the expected accent-insensitive order. Thank you in advance if any of you has any clue that could guide us to a solution. Best regards. — Reply to this email directly, view it on GitHub<#16>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AC7ZLOHBTRA2T5R757M7C7TXCFQMNANCNFSM6AAAAAAXFX727U>. You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[JMG74]

Hi Niels, I did some more investigations in the code and I think I've found the source of the problem.
In fact, this is not due to the fetchXML expression used because the list of items displayed on screen is sorted by Javascript in file operation.tsx on line 34:
allOptions.sort((a,b) => (a.text > b.text) ? 1 : ((b.text > a.text) ? -1 : 0))

Here is one example to illustrate the problem:

The array of French words to sort:	['Zoo','zoo','Zoé','zoé','Edition', 'Editeur', 'Editions', 'Édition','Éditeur', 'Éditions']
The expected result	['Editeur', 'Éditeur', 'Edition', 'Édition', 'Editions', 'Éditions', 'zoé', 'Zoé', 'zoo', 'Zoo']
Using current code :	['Zoo','zoo','Zoé','zoé','Edition','Editeur', 'Editions', 'Édition', 'Éditeur', 'Éditions'].sort((a,b) => (a > b) ? 1 : ((b > a) ? -1 : 0))
the result is:	['Editeur', 'Edition', 'Editions', 'Zoo', 'Zoé', 'zoo', 'zoé', 'Éditeur', 'Édition', 'Éditions']... and the order is wrong!

To fix the problem, we can use Javascript function Intl.Collator().compare (I discovered it during my investigations!).
Using the code ['Zoo','zoo','Zoé','zoé','Edition','Editeur', 'Editions', 'Édition', 'Éditeur', 'Éditions'].sort((a,b) => Intl.Collator().compare(a,b)) is giving: ['Editeur', 'Éditeur', 'Edition', 'Édition', 'Editions', 'Éditions', 'zoé', 'Zoé', 'zoo', 'Zoo'] and it's matching perfectly what I'm expecting!

Function Intl.Collator().compare works perfectly for sorting French words but might need extra options for other languages like Finish or German to get a proper accent-insensitive sorting order. In such cases, it would be necessary to define 2 new optional parameters when configuring the NNDropDown component:

• sortingLocale : type String. Empty or null by default but can be 'fr', 'fi, ...
• sortingOptions : type Object. Empty or null by default. For possible value, see https://tc39.es/ecma402/#collator-objects

Finally, line 34 in operation.tsx could be replaced by something like:
allOptions.sort((a,b) => Intl.Collator(sortingLocale,sortingOptions).compare(a.text,b.text))

As I'm not used to work with Github nor with PCF components, I cannot do the changes (and the tests) on my side... and I would greatly appreciate that you make them for me.
Many thanks in advance.