Live query can't result in UI #7814

CodingOctocat · 2024-06-16T04:32:13Z

CodingOctocat
Jun 16, 2024

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 · 2024-06-16T18:13:50Z

nirinchev
Jun 16, 2024
Maintainer

What tutorial are you referring to?

5 replies

CodingOctocat Jun 16, 2024
Author

MongoDB/Quick Start - .NET SDK

nirinchev Jun 17, 2024
Maintainer

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 Jun 17, 2024
Author

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

nirinchev Jun 17, 2024
Maintainer

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 Jun 18, 2024
Author

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.

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Live query can't result in UI #7814

Uh oh!

{{title}}

Uh oh!

Replies: 1 comment 5 replies

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Select a reply

Uh oh!

Live query can't result in UI #7814

Uh oh!

CodingOctocat Jun 16, 2024

Replies: 1 comment · 5 replies

Uh oh!

nirinchev Jun 16, 2024 Maintainer

Uh oh!

CodingOctocat Jun 16, 2024 Author

Uh oh!

nirinchev Jun 17, 2024 Maintainer

Uh oh!

CodingOctocat Jun 17, 2024 Author

Uh oh!

nirinchev Jun 17, 2024 Maintainer

Uh oh!

CodingOctocat Jun 18, 2024 Author

CodingOctocat
Jun 16, 2024

Replies: 1 comment 5 replies

nirinchev
Jun 16, 2024
Maintainer

CodingOctocat Jun 16, 2024
Author

nirinchev Jun 17, 2024
Maintainer

CodingOctocat Jun 17, 2024
Author

nirinchev Jun 17, 2024
Maintainer

CodingOctocat Jun 18, 2024
Author