Hi, Im creating a visual that displays a table and the customer would like the option to use the MultiCheckbox option to select the names of various channels which then filters the table to only show rows associated with the selected channels.
Ive tried various ways but using TableRowFilter it will only filter correctly if only one tick box is selected and if I use ClientSideRowFilter the table doesnt populate at all even when no check boxes are selected. Maybe this is due to it being only a partial table?
So when using TableRowFilter what would be the correct syntax to get the table to filter on multiple selected variables. Below is the current shape data.
The TableRowFilter can have multiple filters by using the following syntax:
TableRowFilter:*PID*=*value to filter*;*PID2*=*value to filter*
(PID : parameter ID)
- if PID == PID2: the filters are combined through an OR operation
- if PID != PID2: the filters are combined through an AND operation
Having said that, you will need to use the first option, i.e. filtering multiple times parameter 2103. Of course, the only thing left is to transform your session variable 'SelectedServiceTags' to this syntax. You can do that by means of using the RegexReplace placeholder. Make a replacement pattern based on the separator and replace by '2103=$1;'.
If the value of your session variable would be 'test&test2', it would be replaced with 2103=test;2103=test2
The parameterControlOptions will eventually be configured to something like this:
[sep:|@]TableRowFilter:2103=[RegexReplace:(\&),[var:SelectedServiceTags],;2103=]
Hi Jarno, Just had to remove the $1 at the end of the TableRowFilter and all worked as expected. Many thanks