Live query can't result in UI

[CodingOctocat]

Am I misunderstanding the tutorial? Why query results with Where() are not displayed in the UI list?

var project = await GetProjectsFromRealmAsync();

AllFireProjects = project;

// Bind to xaml CollectionView, UI can show result, and if insert item, UI can auto refresh
AllFireProjects = project
    .OrderByDescending(x => x.UpdatedTime)
    .ThenByDescending(x => x.CreatedTime)
    .ThenBy(x => x.IsConfirmCompleted)
    .ThenBy(x => x.CompletedItemCount)
    .ThenBy(x => x.Name);

// Bind to xaml CollectionView, ⚠️UI can not show result
// if remove Where(), UI can show result
CompletedFireProjects = project
    .Where(x => x.IsConfirmCompleted == true)
    .OrderByDescending(x => x.UpdatedTime)
    .ThenByDescending(x => x.CreatedTime)
    .ThenBy(x => x.Name);

// Bind to xaml CollectionView, ⚠️UI can not show result
// if remove Where(), UI can show result
IncompleteFireProjects = project
    .Where(x => x.IsConfirmCompleted == false)
    .OrderByDescending(x => x.UpdatedTime)
    .ThenByDescending(x => x.CreatedTime)
    .ThenBy(x => x.Name);

[nirinchev]

What tutorial are you referring to?

[CodingOctocat]

MongoDB/Quick Start - .NET SDK

[nirinchev]

I can't see a IsConfirmCompleted property on that page or a GetProjectsFromRealmAsync method. Can you post the relevant code snippets or - even better - share a project that reproduces the issue.

[CodingOctocat]

GetProjectsFromRealmAsync just return realm.All<FireProject>()，and IsConfirmCompleted: bool

[nirinchev]

There's no obvious reason why that shouldn't work - filtering a query is something supported and tested with unit tests. Do you get any results if you only apply the filter but don't apply a sort?

[CodingOctocat]

I'm not sure, I've switched to sqlite because there's a bigger problem with reaml, It does not support creating a database in external storage, and I will do more testing when I have time. By the way, AllFireProjects may have the same problem, It can display data in the UI simply because it is first assigned to AllFireProjects = project.