URS-061 · LOT policy defined per product with dropdown
Status: PASS · Duration: 1m 26s · Run Date: April 21, 2026
Test Scenarios
Section titled “Test Scenarios”Step 1: Open Products list
Section titled “Step 1: Open Products list”
Step 2: Open Product A
Section titled “Step 2: Open Product A”
Step 3: All policy options visible
Section titled “Step 3: All policy options visible”
Step 4: Approved Lots Only selected
Section titled “Step 4: Approved Lots Only selected”
Step 4: Approved policy saved
Section titled “Step 4: Approved policy saved”
Step 5: Add approved lots
Section titled “Step 5: Add approved lots”
Step 6: Product B default policy
Section titled “Step 6: Product B default policy”
Step 7: LOT enforcement
Section titled “Step 7: LOT enforcement”
Recordings
Section titled “Recordings”step 01 open products
Section titled “step 01 open products”step 02 open product a
Section titled “step 02 open product a”step 03 tracking policy options
Section titled “step 03 tracking policy options”step 04 set approved policy
Section titled “step 04 set approved policy”step 05 add approved lots
Section titled “step 05 add approved lots”step 06 product b default
Section titled “step 06 product b default”step 07 order enforcement
Section titled “step 07 order enforcement”Database Validations
Section titled “Database Validations”Product A (SpeedPatch) lot_policy = “approved”
Section titled “Product A (SpeedPatch) lot_policy = “approved””Row for SKU SP019N1A should have lot_policy = ‘approved’
SELECT id, sku, title, lot_policy, updated_at FROM org_products WHERE organization_id = $1 AND sku = $2| id | sku | title | lot_policy | updated_at |
|---|---|---|---|---|
| 01989ca2-6a54-7834-8376-06a0251bacd8 | SP019N1A | SpeedPatch® PET | approved | 2026-04-21T03:45:13.376Z |
Product B (FiberLocker) lot_policy = “any”
Section titled “Product B (FiberLocker) lot_policy = “any””Row for SKU FL516SNA should have lot_policy = ‘any’
SELECT id, sku, title, lot_policy, updated_at FROM org_products WHERE organization_id = $1 AND sku = $2| id | sku | title | lot_policy | updated_at |
|---|---|---|---|---|
| 01989ca1-f2f8-7ab7-8269-7179342797cc | FL516SNA | FiberLocker® Instrument SN | any | 2026-04-21T03:44:36.645Z |
Approved lots saved for Product A
Section titled “Approved lots saved for Product A”URS061-prefixed allowed-lot rows for SpeedPatch should be exactly URS061-BATCH-2025Q1, URS061-BATCH-2025Q2
SELECT pal.lot_value, pal.comment, pal.expiration FROM org_product_allowed_lots pal JOIN org_products p ON p.id = pal.org_product_id WHERE p.organization_id = $1 AND p.sku = $2 AND pal.lot_value LIKE 'URS061-%' ORDER BY pal.lot_value| lot_value | comment | expiration |
|---|---|---|
| URS061-BATCH-2025Q1 | ||
| URS061-BATCH-2025Q2 |
Product B has no URS061- allowed lots
Section titled “Product B has no URS061- allowed lots”FiberLocker should have no test-prefixed allowed-lot rows (contrast case)
SELECT pal.lot_value FROM org_product_allowed_lots pal JOIN org_products p ON p.id = pal.org_product_id WHERE p.organization_id = $1 AND p.sku = $2 AND pal.lot_value LIKE 'URS061-%'No rows returned.