I have a functioning Kinetic dashboard that uses the client filter on the provider model. It works fine and I need to use the client filter instead of a where clause for this grid.
I need to add a dynamic filter for our new site now but I can’t find the right syntax to use in the client filter. I have a value bound to Transview.SiteFilter and I want to use a like condition to allow it to filter for each site individually, or all sites together (3 radio buttons).
When I use the condition and hard code any of: ‘%’, ‘Maple’, ‘Innisfil’
the filter works fine. I just can’t figure out the correct syntax to reference the Transview field I am using. I’ve tried every combination of curly brackets, question marks, single quotes that I can think of and nothing seems to work. Has anyone done this before?
