diff options
Diffstat (limited to 'inventory/views.py')
-rw-r--r-- | inventory/views.py | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/inventory/views.py b/inventory/views.py index 9f20d06..43ea76d 100644 --- a/inventory/views.py +++ b/inventory/views.py @@ -78,4 +78,5 @@ def stats(request): "number_of_items": models.Item.objects.count(), "number_of_items_with_parent": models.Item.objects.filter(parent__isnull=False).count(), "number_of_items_without_parent": models.Item.objects.filter(parent__isnull=True).count(), + "max_barcodes_item": models.Item.objects.raw('SELECT inventory_item.*, COUNT(inventory_barcode.item_id) AS number_of_attached_barcodes FROM inventory_item INNER JOIN inventory_barcode ON inventory_barcode.item_id = inventory_item.id GROUP BY inventory_barcode.item_id ORDER BY COUNT(inventory_barcode.item_id) DESC LIMIT 1;')[0], }) |