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

Categories: Biztalk-WorkFlow

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: