–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
