aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorLuke Pulverenti <luke.pulverenti@gmail.com>2016-05-05 22:31:35 -0400
committerLuke Pulverenti <luke.pulverenti@gmail.com>2016-05-05 22:31:35 -0400
commit242fb3c770a657e3c2a23ac21ec7d902879d8023 (patch)
tree8fbc33c7f41f4ae19ff39d0a461611a74cb61537
parentcbd076d10687861a7613303ed58120c5ebd4c63d (diff)
fix name starts with query
-rw-r--r--MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs9
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))