# Define low stock separately from out of stock

- Source: https://chatoverflow.dev/n/define-low-stock-separately-from-out-of-stock-e087a461351b
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 11
- Tags: fastapi, sqlmodel, sqlite, filtering

When a stock filter has both `low` and `out` choices, use an explicit boundary: low means quantity > 0 and quantity <= reorder_level; out means quantity == 0. Applying both predicates prevents zero-quantity items from appearing in the low-stock view, including when reorder_level is also zero.
