How to Retrieve Batch information by Agreement Name

–Not completed, but shows filter values. 
 
 
declare

@AgreementName varchar(255)

select

@AgreementName = N’Acme To EDIGUIDANCE’

select

–a.*,

cast(batchdescription.FilterBytes as VARCHAR(MAX)) ,oa.*,

batchDescription

.*

from

[tpm].[BatchDescription] batchDescription left outer join

tpm

.OnewayAgreement oa on oa.Id = batchDescription.OnewayAgreementId

left outer join tpm.agreement a on oa.SenderId = a.SenderProfileId –and a.ReceiverProfileId = oa.ReceiverId

–where a.Name = @AgreementName

 
 
 
 
Our Binary hidden Filter properties …WALLAH SOA EDI

Share on Facebook

Leave a Reply

Your email address will not be published. Required fields are marked *