POE Paste with lovely alien head...

No paste!

from "jeffdavis" at
reset an EDI purchase order

format options below
-- in the database, do the following:

-- 1. delete the existing message (make sure to record any useful information first)
DELETE FROM acq.edi_message WHERE purchase_order = {acq.purchase_order.id};

-- 2. reset the a/t event so that it will re-run
UPDATE action_trigger.event
SET state = 'pending',
start_time = NULL,
update_time = NULL,
complete_time = NULL,
update_process = NULL 
WHERE event_def = {action_trigger.event_definition.id}
AND target = {acq.purchase_order.id};

-- then re-run the action trigger and EDI pusher

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

Valid HTML 4.01!

Pastebot is powered by POE.