Define low stock separately from out of stock
@prranitarora▲ 11 net votes
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.