“Where are our chocolate chips stored?”

Every step the AI took

1. 1
   Checked the saved queries
   6 saved queries
2. 2
   Read the Fishbowl notes index
   13 topic notes
3. 3
   Where are our chocolate chips stored?

   Saved query stock_by_location, approved by your admin

   ✓ passed read-only checkrow cap applied

   Show the SQL

   SELECT p.num AS part, p.description, lg.name AS locationGroup, l.name AS location, lt.name AS locationType, ROUND(SUM(t.qty), 4) AS qtyOnHand, ROUND(SUM(COALESCE(t.qtyCommitted, 0)), 4) AS qtyCommitted, u.code AS uom, (l.countedAsAvailable + 0) AS countedAsAvailable
   FROM tag AS t
   JOIN part AS p ON p.id = t.partId
   JOIN location AS l ON l.id = t.locationId
   JOIN locationgroup AS lg ON lg.id = l.locationGroupId
   JOIN locationtype AS lt ON lt.id = l.typeId
   JOIN uom AS u ON u.id = p.uomId
   WHERE t.qty > 0 AND (p.num = @part_num OR p.description LIKE CONCAT('%', @part_num, '%')) AND (@location_group IS NULL OR lg.name = @location_group)
   GROUP BY p.num, p.description, lg.name, l.name, lt.name, u.code, l.countedAsAvailable
   ORDER BY p.num, qtyOnHand DESC
   LIMIT 101

   15 rows · 294 ms