Using a view within a js API query to a table.
Is it possible to use a view when using the js API with a table.
For example I have a table called drafted_teams and a drafted_players table which has a foreign key relation to the drafted_teams table as well as a relation to the players table.
I have also set up a view called player_view which filters out a bunch of data from the players table as well as doing some logic to set other columns.
When using the JS API to select from the drafted_teams table and join the drafted_players. Is it possible to use the view when joining the player data instead of getting the data from the players table?
Hopefully that makes sense. I'm on mobile so don't currently have access to the exact query I will be running.
For example I have a table called drafted_teams and a drafted_players table which has a foreign key relation to the drafted_teams table as well as a relation to the players table.
I have also set up a view called player_view which filters out a bunch of data from the players table as well as doing some logic to set other columns.
When using the JS API to select from the drafted_teams table and join the drafted_players. Is it possible to use the view when joining the player data instead of getting the data from the players table?
Hopefully that makes sense. I'm on mobile so don't currently have access to the exact query I will be running.
