Hello,
we are using the xamDataGrid and we need to filter accent insensitive.
For example we try to filter for a city in France: "Orléans".
We want to find it by typing "Orleans".
We cannot use an additional column with normalized strings, because we
don't know the resulting columns at compile time.
Has anybody an idea for a solution?
Thank you
Hello Lothar,
Since the diacritics, for example "e" ,"é" are different letters, which have different codes the XamDataGrid's filtering treats them differently.
Depending on your scenario and requirements you can create a custom filtering logic. You can use External Filtering. The External Filtering uses CollectionView object. You can activate it through UseCollectionView property. Please also note that if there are any filtering logic set using the Filter property of the ICollectionView implementing data source, it will be overwritten by the XamDataGrid's filtering criteria which are supplied through this property.
You can find more about External Filtering in the documentation topic:
http://www.infragistics.com/help/wpf/xamdatagrid-external-filtering
Hi Nick,
can I use External Filtering with CollectionView when I have a DataTable as Datasource?
At the moment I have no idea how to use this with my Problem.
I'm thinking about an other Solution:
Is it possible to implement my own CompareOperator?
Something like "ContainsExtended"
For your first question, yes you can use CollectionView and set its source to be DataTable.
If you want to type "e" and find words which contain "é", like in your example with Orleans, I will suggest a different approach.You can change the text that has been searched by replacing the characters. You can achieve that by using RecordFilterChanged event.Following this approach I have created a small sample application.
Let me know if you have further questions concerning this matter.