POE Paste with lovely alien head...

No paste!

from "mmorgan" at
Cancel transits for items with status other than In transit

format options below
update action.transit_copy
set cancel_time = now()
where id in
SELECT atc.id
FROM action.transit_copy atc
join asset.copy ac on atc.target_copy = ac.id
WHERE dest_recv_time IS NULL AND cancel_time IS NULL
and ac.status != 6
order by id desc

perl stuff: (might be helpful for others but not perfect)

Valid HTML 4.01!

Pastebot is powered by POE.