rackem
Well-Known Member
I am having a problem getting a pre-filter to work on a dbjoin element. This is a local setup so I can't show you but here is my setup.
I have two lists - Players and Votes. My Votes list is linked to the player list using a dbjoin element. Users can vote on players. However some players are inactive so I want to be able to hide the votes for inactive players.
So my pre-filter is set to the following:
WHERE
Field: Player(raw)
Condition: IN
Value: SELECT `id` FROM `mps_wi_ranking` WHERE `active` = 1
Type: Query
All the values are shown in my list. I have verified the query works in phpMyAdmin. I have tried "Player" and "Player(raw"). I have even tried a simple EQUALS pre-filter set to a single value but that didn't work either.
I have two lists - Players and Votes. My Votes list is linked to the player list using a dbjoin element. Users can vote on players. However some players are inactive so I want to be able to hide the votes for inactive players.
So my pre-filter is set to the following:
WHERE
Field: Player(raw)
Condition: IN
Value: SELECT `id` FROM `mps_wi_ranking` WHERE `active` = 1
Type: Query
All the values are shown in my list. I have verified the query works in phpMyAdmin. I have tried "Player" and "Player(raw"). I have even tried a simple EQUALS pre-filter set to a single value but that didn't work either.