diff options
| author | Étienne Loks <etienne.loks@iggdrasil.net> | 2026-04-12 19:08:41 +0200 |
|---|---|---|
| committer | Étienne Loks <etienne.loks@iggdrasil.net> | 2026-04-15 17:05:17 +0200 |
| commit | 59f9cb8443c62e707daecf52d1400e0b72f598dc (patch) | |
| tree | a9aaaec3e678f308b26d6ea80ed681a06b4dbd82 | |
| parent | c99101889c140c1cb60e6a416a8d238379fa5245 (diff) | |
| download | Ishtar-59f9cb8443c62e707daecf52d1400e0b72f598dc.tar.bz2 Ishtar-59f9cb8443c62e707daecf52d1400e0b72f598dc.zip | |
⚡ search: small improvment on && searches
| -rw-r--r-- | ishtar_common/views_item.py | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/ishtar_common/views_item.py b/ishtar_common/views_item.py index 405920dd9..11d7a5345 100644 --- a/ishtar_common/views_item.py +++ b/ishtar_common/views_item.py @@ -41,6 +41,7 @@ from django.db.models import ( F, Q, Count, + Subquery, Sum, ImageField, ExpressionWrapper, @@ -2887,11 +2888,11 @@ def get_item( if split_type == "OR": items |= sub_items else: - # in Django m2m queries use the same JOIN... + # in Django m2m queries use the same JOIN # items &= sub_items do not work - items &= model.objects.filter(Q( - pk__in=list(sub_items.values_list("pk", flat=True)) - )) + items &= model.objects.filter( + id__in=Subquery(sub_items.values("id")) + ) if return_query: return items |