arcadeicons
Member
I have a relationship table that ties game scores to the global title of the game in question. The relationship table is the specific-game that a user owns.
If a user deletes a game they own from their collection, it breaks the relationship between their previously posted scores and the global game title.
I want to write a pre-filter on my 'Latest Scores' module that checks to see if the game-relationship table id even exists before showing the score.
submit_score.gameID joins to select_game.id, so if select_game.id no longer exists I dont want to show that score.
something like
if submit_score.gameID EXISTS in select_game.id then display submit_score.score
I'm not sure how to construct this in the module pre-filter dropdowns.
If a user deletes a game they own from their collection, it breaks the relationship between their previously posted scores and the global game title.
I want to write a pre-filter on my 'Latest Scores' module that checks to see if the game-relationship table id even exists before showing the score.
submit_score.gameID joins to select_game.id, so if select_game.id no longer exists I dont want to show that score.
something like
if submit_score.gameID EXISTS in select_game.id then display submit_score.score
I'm not sure how to construct this in the module pre-filter dropdowns.