Let users dynamically filter a grid by multiple selections

[jbooker (Josh Booker)]

Another thing I wanna try but havn’t yet is a BAQ having input param that takes delimited list and then cross apply split_string like so:

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

With MSSQL 2016+ you can cross apply string_split like so (remove ordinal for better perf or not 2022+) SELECT InvcHead.Company AS InvcHead_Company, InvcHead.InvoiceNum AS InvcHead_InvoiceNum, s.value AS Split_SalesRep, s.ordinal AS SalesRep_Order -- mssql2022+ FROM InvcHead CROSS APPLY STRING_SPLIT(InvcHead.SalesRepList, '~', 1) s ORDER BY InvcHead.InvoiceNum, s.ordinal; InvcHead_Company InvcHead_InvoiceNum Split_SalesRep SalesRep_Order 111111 1001 RepA 1 111111 10…