diff options
| author | Luke Pulverenti <luke.pulverenti@gmail.com> | 2016-05-05 22:31:35 -0400 |
|---|---|---|
| committer | Luke Pulverenti <luke.pulverenti@gmail.com> | 2016-05-05 22:31:35 -0400 |
| commit | 242fb3c770a657e3c2a23ac21ec7d902879d8023 (patch) | |
| tree | 8fbc33c7f41f4ae19ff39d0a461611a74cb61537 | |
| parent | cbd076d10687861a7613303ed58120c5ebd4c63d (diff) | |
fix name starts with query
| -rw-r--r-- | MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs | 9 |
1 files changed, 1 insertions, 8 deletions
diff --git a/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs b/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs index 291ef7375..d825a8de9 100644 --- a/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs +++ b/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs @@ -2097,14 +2097,7 @@ namespace MediaBrowser.Server.Implementations.Persistence } if (!string.IsNullOrWhiteSpace(query.NameStartsWith)) { - if (_config.Configuration.SchemaVersion >= 66) - { - whereClauses.Add("CleanName like @NameStartsWith"); - } - else - { - whereClauses.Add("Name like @NameStartsWith"); - } + whereClauses.Add("SortName like @NameStartsWith"); cmd.Parameters.Add(cmd, "@NameStartsWith", DbType.String).Value = query.NameStartsWith + "%"; } if (!string.IsNullOrWhiteSpace(query.NameStartsWithOrGreater)) |
