BPM Query List of Tilde Delimited Values

[Mark_Wonsil]

Maybe you can glean something from what Jose did with a CTE for Sales Reps (also tilde delimited).

Trying to create a BAQ that lists sales by salesperson. Problem is SalesRepList can hold multiple. Help!

Here is a Basic BAQ which does this using a CTE (Give it a shot if you’d like) RepListFromIvcHead.baq (30 KB) (>10.2.100) with [SubQuery1] as (select [InvcHead].[Company] as [InvcHead_Company], [InvcHead].[InvoiceNum] as [InvcHead_InvoiceNum], [InvcHead].[SalesRepList] as [InvcHead_SalesRepList], (2) as [Calculated_num], ([Ice].entry(1 ,InvcHead.SalesRepList, '~')) as [Calculated_SalesRe] from Erp.InvcHead as InvcHead union all select [SubQuery1].[InvcHead_Company] as […