Let users dynamically filter a grid by multiple selections

[d_inman (David Inman)]

We are trying to recreate within Kinetic a Power BI dashboard that is simply a table of employees with their labor hours for a given day, but users are asking for the ability for the grid to only show the specific employees that they want to see. Is there a way to allow users to make multiple filter selections on a single grid in Application Studio? (we’re on version 2024.1.9)

For example, in the Power BI dashboard they may select a supervisor, which changes the list of employees in the grid to only that supervisor’s reports. It also updates another filter panel to only show their reports and allows them to select one or more and only see those specific employees. Or they can skip choosing a supervisor and select one or more employees to filter the table to only those employees.

We don’t necessarily need the list of employees to change based on the supervisor chosen, but we would like the labor hours grid to update to show the multiple employees that they choose.

[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.

[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…

[jkane (John Kane)]

Depending on what version you are on, you may want to try this Preview Feature.

[Patrick (Patrick Winter)]

@d_inman

We don’t necessarily need the list of employees to change based on the supervisor chosen, but we would like the labor hours grid to update to show the multiple employees that they choose.

One option - Maybe not the best.
Let the user tag the employee records with the same tag “MyTags01”.
Link to the tags table in the DB and display the MyTags field as a column they can filter on.

[d_inman (David Inman)]

Hmm, that has me wondering if we could do something like a separate card of employee names with a select column and when the select is checked do something like set a Transview column = 1 for that employee and then somehow use that in the subscribed labor detail grid to filter for those employees, filtering on the 1.

[d_inman (David Inman)]

Nice suggestion, but we’re on-prem on 2024.1.9, not planning to upgrade until 2025.1.10/12 or somewhere around there this Fall. I did try turning on Advanced Filtering for the grid in Application Studio, but that only gives the option to select one or two different values in a column.