Apply a filter on a sorted ListCollectionView/ObservableCollection

Question

What I have

I have a UserControl made of a TextBox and a ListBox. The ListBox has its ItemsSource bound to an ObservableCollection in a DataContext via a ListCollectionView with a custom sorting and filter as we'll see below. The purpose of the control is to display in the ListBox only the items (strings) in the source collection that contain the text in the TextBox. For that purpose I apply a filter on the ListCollectionView.

I have two additional constraints. 1, my original collection is not alphabetically sorted but the items displayed in the ListBox are using a ListCollectionView CustomSort. 2, I must display only the first 5 items (alphabetically sorted) that match the string in the TextBox. I apply a filter on the ListCollectionView for that.

Expectation

Let's say my collection is defined as such in my DataContext:

this.AllItems = new ObservableCollection
{
    "Banana", 
    "Watermelon",
    "Peach",
    "Grape",
    "Apple",
    "Pineapple",
    "Cherry",
    "Durian",
    "Rambutan",
    "Strawberry",
    "Raspberry",
    "Lemon",
    "Orange",
    "Sugar cane",
    "Guava",
    "Tomato",
    "Coconut",
    "Melon",
    "Äpple",
    "Glaçon",
    "Etape",
    "Étape"
};

And in my TextBox I input the letter 'e' (all comparisons done are case-insenstive). I expect the ListBox to display the following 5 items (CurrentUICulture is set to fr-FR):

Apple
Äpple
Cherry
Etape
Étape

because they are the first 5 items that contain the letter 'e' when sorted alphabetically. However I get the following items in my application:

Apple
Grape
Peach
Pineapple
Watermelon

because they are the first 5 items in my collection that contain the letter 'e' THEN sorted alphabetically.

My code

Here's the code to understand what I have and my problem. It should work virtually only using a copy/paste of the below (beware of namespaces and CurrentUICulture). I'm using C# 4.0.

1) The MainWindow

2) The class used as the DataContext

public class FoobarViewModel : INotifyPropertyChanged
{
    private ObservableCollection allItems;
    public event PropertyChangedEventHandler PropertyChanged;

    public FoobarViewModel()
    {
        this.AllItems = new ObservableCollection
        {
            "Banana", 
            "Watermelon",
            "Peach",
            "Grape",
            "Apple",
            "Pineapple",
            "Cherry",
            "Durian",
            "Rambutan",
            "Strawberry",
            "Raspberry",
            "Lemon",
            "Orange",
            "Sugar cane",
            "Guava",
            "Tomato",
            "Coconut",
            "Melon",
            "Äpple",
            "Glaçon",
            "Etape",
            "Étape"
        };
    }

    public ObservableCollection AllItems
    {
        get
        {
            return this.allItems;
        }
        set
        {
            this.allItems = value;
            this.OnPropertyChanged("AllItems");
        }
    }

    private void OnPropertyChanged(string propertyName)
    {
        var handler = this.PropertyChanged;
        if (handler != null)
        {
            handler(this, new PropertyChangedEventArgs(propertyName));
        }
    }
}

3) The XAML of my UserControl

4) And finally, most important the code behind of my UserControl Foobar.

public partial class Foobar : UserControl
{
    #region Fields
    public static readonly DependencyProperty AllItemsProperty = DependencyProperty.Register(
        "AllItems",
        typeof(IEnumerable),
        typeof(Foobar),
        new PropertyMetadata(AllItemsChangedCallback));

    private const int MaxItems = 5;
    #endregion

    #region Constructors
    public Foobar()
    {
        InitializeComponent();

        textbox.KeyUp += TextboxKeyUp;
    }
    #endregion

    #region Properties
    public IEnumerable AllItems
    {
        get { return (IEnumerable)this.GetValue(AllItemsProperty); }
        set { this.SetValue(AllItemsProperty, value); }
    }
    #endregion

    #region Methods
    private void TextboxKeyUp(object sender, KeyEventArgs e)
    {
        TextBox localTextBox = sender as TextBox;
        if (localTextBox != null)
        {
            var items = ((ListCollectionView)listbox.ItemsSource).SourceCollection;

            if (items.Cast().Any(x => x.ToLower(CultureInfo.CurrentUICulture).Contains(localTextBox.Text.ToLower(CultureInfo.CurrentUICulture))))
            {
                this.ApplyFilter();
                listbox.Visibility = Visibility.Visible;
            }
            else
            {
                listbox.Visibility = Visibility.Collapsed;
            }
        }
    }

    private static void AllItemsChangedCallback(DependencyObject sender, DependencyPropertyChangedEventArgs e)
    {
        Foobar control = sender as Foobar;
        if (control != null)
        {
            List source = new List((IEnumerable)e.NewValue);

            ListCollectionView view = (ListCollectionView)CollectionViewSource.GetDefaultView(source);
            view.CustomSort = new CustomSort();
            control.listbox.ItemsSource = view;
            control.ApplyFilter();
        }
    }

    private void ApplyFilter()
    {
        ListCollectionView view = (ListCollectionView)listbox.ItemsSource;

        int index = 0;
        view.Filter = x =>
        {
            bool result = x.ToString().ToLower(CultureInfo.CurrentUICulture).Contains(textbox.Text.ToLower(CultureInfo.CurrentUICulture));
            if (result)
            {
                index++;
            }

            return index <= MaxItems && result;
        };
    }
    #endregion

    private class CustomSort : IComparer
    {
        public int Compare(object x, object y)
        {
            return String.Compare(x.ToString(), y.ToString(), CultureInfo.CurrentUICulture, CompareOptions.IgnoreCase);
        }
    }
}

The whole code is working as expected, except the filtering which is done in the ApplyFilter method. Basically, this method just checks each and every item in the collection against whatever is in the TextBox and provided there is not already more than the maximum number of items returned, the item will be included in the filter. When I debug this method, I can see that items are browsed in the original order of the collection and not in the sorted order althought the filter seem to be done on the ListCollectionView and not the ObservableCollection.

It seems the filter is applied first, then the sorting. I want the sorting to apply first then the filtering.

My question

How can I apply the filter on the sorted ListCollectionView and not on the original non-sorted collection?

Lukazoid · Accepted Answer

Why not create a generic IComparer and use the Enumerable.OrderBy(IEnumerable, Func, IComparer) extension method before you create the collection view.

So you end up with something like:

private static void AllItemsChangedCallback(DependencyObject sender, DependencyPropertyChangedEventArgs e)
{
    Foobar control = sender as Foobar;
    if (control != null)
    {
        var newEnumerable = (IEnumerable)e.NewValue;
        var sorted = newEnumerable.OrderBy(s => s, new CustomSort());
        var source = new List(sorted);

        var view = (ListCollectionView)CollectionViewSource.GetDefaultView(source);
        control.listbox.ItemsSource = view;
        control.ApplyFilter();
    }
}

private class CustomSort : IComparer
{
    public int Compare(string x, string y)
    {
        return String.Compare(x, y, CultureInfo.CurrentUICulture, CompareOptions.IgnoreCase);
    }
}

Then your collection view is already sorted and filtering can be applied.

Apply a filter on a sorted ListCollectionView/ObservableCollection

Answers (1)

Related Questions