diff options
| author | Cody Robibero <cody@robibe.ro> | 2021-12-31 08:03:08 -0700 |
|---|---|---|
| committer | Cody Robibero <cody@robibe.ro> | 2021-12-31 08:03:08 -0700 |
| commit | c3071f89966039009a618efae56cbf1ab2f039d5 (patch) | |
| tree | e52920cace66e89854f172c17b660d71b1b46dae | |
| parent | dc9e1ece2929dbe64a5af6e10a0594f5b3e9bb5c (diff) | |
Fix orderby query
| -rw-r--r-- | Emby.Server.Implementations/Data/SqliteItemRepository.cs | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/Emby.Server.Implementations/Data/SqliteItemRepository.cs b/Emby.Server.Implementations/Data/SqliteItemRepository.cs index 47d10b0ac..d5c0b7107 100644 --- a/Emby.Server.Implementations/Data/SqliteItemRepository.cs +++ b/Emby.Server.Implementations/Data/SqliteItemRepository.cs @@ -3016,8 +3016,8 @@ namespace Emby.Server.Implementations.Data return " ORDER BY " + string.Join(',', orderBy.Select(i => { var columnMap = MapOrderByField(i.OrderBy, query); - - return columnMap.SortBy + " " + columnMap.SortOrder; + var sortOrder = columnMap.SortOrder == SortOrder.Ascending ? "ASC" : "DESC"; + return columnMap.SortBy + " " + sortOrder; })); } |