Tuesday, July 22, 2014

Sterling Integrator AS2 Transaction Details Query

select
msgmdncor.mdn_message_id,
msgmdncor.wf_id,
doc.body_name,
msgmdncor.create_date
from MSGMDNCORRELATION msgmdncor,
document doc
where
msgmdncor.create_date like 'choose some date' and
doc.workflow_id = msgmdncor.wf_id and
doc.body_name like '%Somefilename pattrean%'