List filtered by element

[SoilentRed]

I'm using the juser plugin to register users to a players list. I have another list for schools. When a user signs up, they select theirs school based on what's in the schools list. The players list captures the id of the school.

There's another list for game scores where all the players enter scores and data. I would like to create a list view that will show the data of all the players in the player's school.

Is this a prefilter? How do I accomplish this? Your help is always appreciated!

 

[coullet]

I think you can add a pre filter:
field: players_id_raw
condition: in
value: select id from players where school_id=(select school from players where user={$my->id} limit 1)
type: query