jellyfin/tests/Jellyfin.Server.Implementations.Tests/Item, branch master

avoid correlated item value name queries

2026-09-02T09:33:54Z

test legacy item value filter semantics

2026-09-02T09:29:24Z

Potential fix for pull request finding

2026-09-02T09:05:36Z

Co-authored-by: Copilot Autofix powered by AI <175728472+Copilot@users.noreply.github.com>

avoid correlated legacy item value filter queries

2026-09-01T12:37:44Z

The legacy filter queries projected ItemValue before grouping tags and genres. EF Core translated that shape into duplicated correlated aggregates, causing multi-minute requests for libraries with many distinct values and blocking unrelated SQLite-backed API calls. Join ItemValuesMap directly to ItemValues before grouping. This preserves type and item filtering, clean-value grouping, minimum-value selection and ordering while producing one aggregate query. Add an in-memory SQLite regression test for result semantics and both SQL shapes.

Fix recursive handling for LinkedChildren

2026-08-31T15:56:56Z

Count a season's episodes by the season they belong to

2026-08-29T19:39:14Z

Merge pull request #17715 from Shadowghost/fix-people-cleanup

2026-08-25T22:28:52Z

Delete credits nothing maps to and bound item-by-name folder names

Delete a credit once no item maps to it any more

2026-08-25T18:31:30Z

Order IsPlayed and IsUnplayed by the played state the filter reports

2026-08-25T13:19:38Z

Ordering mapped both keys to the item's own stored UserData row. Folders do not have one: a series, season or box set counts as played when no descendant is left unplayed, which is what the isPlayed filter and the DTO both report. A mixed library therefore sorted every series and box set into the unplayed group, and a query could filter and sort by two different notions of "played". Extract the filter's predicate into BuildIsPlayedFilter and route both sort keys through it so the two cannot drift apart again.

Merge remote-tracking branch 'upstream/master' into fix-series-merging

2026-08-22T15:18:01Z