I have a Klip with a table that connects to my SQL database. I've created some User Input Controls to filter the table rows.
I have an issue with one of them because I want to select an Item in the dropdown and if Column 'X' has the value OR Column 'Y' has the value, then filter as so.
This is causing issues as I can only filter by one column it seems.
How can I filter by both columns so that the item I pick in the dropdown will select the value in either column?
The above picture filters by name 'specialist' in Player 1 column. I want it so it shows rows if 'specialist' is in Player 1 OR Player 2 column.
Hope I've explained this ok.