diff options
| author | Mark Monteiro <marknr.monteiro@protonmail.com> | 2020-04-05 10:07:17 -0400 |
|---|---|---|
| committer | Mark Monteiro <marknr.monteiro@protonmail.com> | 2020-04-05 10:07:17 -0400 |
| commit | f91f2ef328a9d7693956ab33bf5c70be2f1213df (patch) | |
| tree | b1e0bba89071f6930e0c9b08c8e6ff086f8120d3 /Emby.Server.Implementations/Data/SqliteItemRepository.cs | |
| parent | f2760cb055ae6ee5971ca4a3ff342ecd7d829d99 (diff) | |
| parent | 29539174a3de47c151cc7c7fd192100e6fbe48d7 (diff) | |
Merge remote-tracking branch 'upstream/master' into register-services-correctly
Diffstat (limited to 'Emby.Server.Implementations/Data/SqliteItemRepository.cs')
| -rw-r--r-- | Emby.Server.Implementations/Data/SqliteItemRepository.cs | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/Emby.Server.Implementations/Data/SqliteItemRepository.cs b/Emby.Server.Implementations/Data/SqliteItemRepository.cs index 8db4146cd..e41d1a0d3 100644 --- a/Emby.Server.Implementations/Data/SqliteItemRepository.cs +++ b/Emby.Server.Implementations/Data/SqliteItemRepository.cs @@ -5010,6 +5010,11 @@ where AncestorIdText not null and ItemValues.Value not null and ItemValues.Type commandText += " order by ListOrder"; + if (query.Limit > 0) + { + commandText += " LIMIT " + query.Limit; + } + using (var connection = GetConnection(true)) { var list = new List<string>(); @@ -5048,6 +5053,11 @@ where AncestorIdText not null and ItemValues.Value not null and ItemValues.Type commandText += " order by ListOrder"; + if (query.Limit > 0) + { + commandText += " LIMIT " + query.Limit; + } + using (var connection = GetConnection(true)) { var list = new List<PersonInfo>(); |