URS-014 · Display Available Inventory for Rep Trunk Stock
Status: PASS · Duration: 49s · Run Date: April 21, 2026
Test Scenarios
Section titled “Test Scenarios”Step 1: Login and navigate
Section titled “Step 1: Login and navigate”
Step 2: Trunk inventory overview
Section titled “Step 2: Trunk inventory overview”
Step 3: Diagnostic Kit details
Section titled “Step 3: Diagnostic Kit details”
Step 4: Sterile Gloves details
Section titled “Step 4: Sterile Gloves details”
Step 5: Antiseptic Solution details
Section titled “Step 5: Antiseptic Solution details”
Step 6: Filter functionality
Section titled “Step 6: Filter functionality”
Recordings
Section titled “Recordings”step 01 login navigate
Section titled “step 01 login navigate”step 02 trunk inventory
Section titled “step 02 trunk inventory”step 03 diagnostic kit
Section titled “step 03 diagnostic kit”step 04 sterile gloves
Section titled “step 04 sterile gloves”step 05 antiseptic solution
Section titled “step 05 antiseptic solution”step 06 filter functionality
Section titled “step 06 filter functionality”Database Validations
Section titled “Database Validations”Inventory items exist at TRUNK-36
Section titled “Inventory items exist at TRUNK-36”Exactly 3 inventory items should exist at TRUNK-36
SELECT count(*)::int as item_count FROM inventory_items ii JOIN org_products op ON ii.product_id = op.id WHERE ii.real_world_location_id = $1 AND op.sku IN ($2, $3, $4) AND ii.organization_id = $5| item_count |
|---|
| 3 |
Product details match expected values
Section titled “Product details match expected values”Each product should have the correct title, lot, quantity, and expiration
SELECT op.title, op.sku, ii.lot, ii.expiration::text, ii.quantity_ready FROM inventory_items ii JOIN org_products op ON ii.product_id = op.id WHERE ii.real_world_location_id = $1 AND op.sku IN ($2, $3, $4) AND ii.organization_id = $5 ORDER BY op.title| title | sku | lot | expiration | quantity_ready |
|---|---|---|---|---|
| Antiseptic Solution (500ml) | URS014-AS-001 | AS-2024-112 | 2026-09-15 | 8 |
| Diagnostic Kit | URS014-DK-001 | DK-2024-001 | 2026-12-31 | 15 |
| Sterile Gloves (Box of 100) | URS014-SG-001 | SG-2024-045 | 2027-06-30 | 50 |
Total inventory quantity is correct
Section titled “Total inventory quantity is correct”Total quantity should be 73 (15 + 50 + 8)
SELECT sum(ii.quantity_ready)::int as total_quantity FROM inventory_items ii JOIN org_products op ON ii.product_id = op.id WHERE ii.real_world_location_id = $1 AND op.sku IN ($2, $3, $4) AND ii.organization_id = $5| total_quantity |
|---|
| 73 |
All items belong to StellarTech org
Section titled “All items belong to StellarTech org”All inventory items should belong to the StellarTech organization
SELECT ii.organization_id, count(*)::int as item_count FROM inventory_items ii JOIN org_products op ON ii.product_id = op.id WHERE ii.real_world_location_id = $1 AND op.sku IN ($2, $3, $4) AND ii.organization_id = $5 GROUP BY ii.organization_id| organization_id | item_count |
|---|---|
| b2c3d4e5-f6a7-8901-bcde-f12345678901 | 3 |