User Tools

Site Tools


Peregrine Orders - New Mechanism

Peregrine are using my new po send mechanism - detailed here:

The new mechanism is super easy to check for outcomes:

-- get PO guid
SELECT * FROM vw_POHdr WHERE po = '?-?'

-- use view for new mechanism
SELECT * FROM [vw_POSend] WHERE guid_po = '?'

-- get same info but joined to job queue for the job that sent the data
SELECT * FROM [vw_POSend_WithJobQueue] WHERE guid_po = '?'
peregrine_orders_-_new_mechanism.txt · Last modified: 2022/03/24 05:30 by