Baq to Dashboard options

[jbooker (Josh Booker)]

You can do this with criteria using IN() clause.

If it’s a parameter baq, make it a list-type param, specify IN() criteria, and make it optional in baq design.

Then filtering in BaqOptions.WhereList string simply go:

IN(?{TransView.DeptListSQL})

Like this example:

You need to pass a single-quoted, comma-delimited string valid for T-SQL IN() clause. for example: 'dept1','dept2' not dept1,dept2 and not dept1~dept2

To format a kinetic list value (such as those returned by mutli-select search or selection-lists, etc you can convert dept1~dept2 to 'dept1','dept2' like so:

Dashboard BAQ Select Multiple Options

Can you share the param value expression? I suspect it’s passing a tilde delimited list rather than one expected by t-sql IN clause. So your BAQ works for in(‘dept1’) but not for in(‘dept1~dept2’). If that’s the case, you can Convert to sql like so: