Rails 24:00 Orvane Home & Outdoor

Ask

Questions are answered from the dictionary's own SQL, so a number here is the number the operator acts on. When a term has two meanings, both answers come back with how far they overlap.

How many active listings do we have?late shipments last 7 daysnet sales this weekchargebacks in the windowclean returns last 30 daysstock on hand

28 chargebacks according to the finance lead (payments v1).

28 chargebacks

28 chargebacks according to the finance lead (payments v1)

Opened by now, due after now and within window_hours; with whether evidence is filed yet.

SQL
SELECT c.id AS chargeback_id, m.name AS marketplace, c.reason, c.amount, c.respond_by,
       c.evidence_filed_at <= TIMESTAMP '2026-11-28 00:00:00' AS evidence_filed
FROM chargebacks c JOIN marketplaces m ON m.id = c.marketplace_id
WHERE c.opened_at <= TIMESTAMP '2026-11-28 00:00:00' AND c.respond_by > TIMESTAMP '2026-11-28 00:00:00' AND c.respond_by <= TIMESTAMP '2026-11-28 00:00:00' + INTERVAL (72) HOUR
ORDER BY c.respond_by