aboutsummaryrefslogtreecommitdiff
path: root/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs
diff options
context:
space:
mode:
authorLuke <luke.pulverenti@gmail.com>2016-07-23 02:18:37 -0400
committerGitHub <noreply@github.com>2016-07-23 02:18:37 -0400
commit7d0a6456080a72d9a3721f13c87dd9292fc65255 (patch)
tree2138ffc8d83096b91f8ac77939544d8b2c0369bb /MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs
parent79f6da09a5730e11608b4c762e07c6e89f7a886f (diff)
parent2aeee846f421ec3a0e943d0cdcdedcdb250904ce (diff)
Merge pull request #1970 from MediaBrowser/dev
Dev
Diffstat (limited to 'MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs')
-rw-r--r--MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs14
1 files changed, 9 insertions, 5 deletions
diff --git a/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs b/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs
index 4f8f31a75..7f556cfb0 100644
--- a/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs
+++ b/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs
@@ -2883,15 +2883,19 @@ namespace MediaBrowser.Server.Implementations.Persistence
whereClauses.Add(clause);
}
- if (query.ExcludeArtistNames.Length > 0)
+ if (query.ExcludeArtistIds.Length > 0)
{
var clauses = new List<string>();
var index = 0;
- foreach (var artist in query.ExcludeArtistNames)
+ foreach (var artistId in query.ExcludeArtistIds)
{
- clauses.Add("@ExcludeArtistName" + index + " not in (select CleanValue from itemvalues where ItemId=Guid and Type <= 1)");
- cmd.Parameters.Add(cmd, "@ExcludeArtistName" + index, DbType.String).Value = artist.RemoveDiacritics();
- index++;
+ var artistItem = RetrieveItem(new Guid(artistId));
+ if (artistItem != null)
+ {
+ clauses.Add("@ExcludeArtistName" + index + " not in (select CleanValue from itemvalues where ItemId=Guid and Type <= 1)");
+ cmd.Parameters.Add(cmd, "@ExcludeArtistName" + index, DbType.String).Value = artistItem.Name.RemoveDiacritics();
+ index++;
+ }
}
var clause = "(" + string.Join(" AND ", clauses.ToArray()) + ")";
whereClauses.Add(clause);