arcadeicons
Member
I'm trying to filter a Cascading Dropdown element
List - "All Tournament games", built from table `repeat_tournament games` and two joined tables, `select_game` and `add_tournament`.
I'm using the following query to successfully filter labels for the dropdown...
But this gives me blanks in the dropdown as it's only filtering labels.
When I try and add a filter to the advanced WHERE clause...
I constantly get the error of unknown column 'select_game.allow_scores'. I've tried placeholders, the column alone but constantly get the same error, even though the column is clearly viewable in the list.
List - "All Tournament games", built from table `repeat_tournament games` and two joined tables, `select_game` and `add_tournament`.
I'm using the following query to successfully filter labels for the dropdown...
Code:
(SELECT name
FROM nfojm_djc2_items, select_game
WHERE nfojm_djc2_items.id = select_game.gamecatalogID
AND select_game.id = {thistable}.add_games
AND select_game.allow_scores <> 'no')But this gives me blanks in the dropdown as it's only filtering labels.
When I try and add a filter to the advanced WHERE clause...
Code:
select_game.allow_scores <> 'no'I constantly get the error of unknown column 'select_game.allow_scores'. I've tried placeholders, the column alone but constantly get the same error, even though the column is clearly viewable in the list.