Let users dynamically filter a grid by multiple selections

[jbooker (Josh Booker)]

This is on my list of things to work out as I havn’t seen it done client-side as far as I recall. Namely, multi-select grid or search to tilde separated list to BAQ whereClause (client-side).
ie: ‘001~002~003’ > EmpNum IN(‘001’,‘002’,‘003’)
I suspect it’s possible, client-side using this (but haven’t yet found it used this way):

Function: convertDelimitedListToSQL?

Does anyone know what the difference between Kinetic-Function and Function? [image] The former is obviously functions designed in Function Maintenance, but what’s the latter? Client-side string manipulation perhaps? I’m especially curious about the tool tip referencing convertDelimitedListToSQL. Sounds like it may be a handy way of dealing with multi-select list parameters in BAQ criteria, maybe? The staff at Insights didn’t know and @pferrington had to leave the conference early I was tol…

I’m sure there are other ways.