1

I have 2 regions in a page, both regions are classic reports displayed as cards. The first report is of team names(built from pl/sql query of a table with column's id, team_name) and the second report is of players(built from pl/sql query of a table with column's id, player_name, team_name & goals scored). Now when I click on a team card in the first region, the second region should only show players of that team which means the where clause in the second region should be changed dynamically. How can I accomplish this?

Improve this question

1 Answer 1

Reset to default
1

What you are looking for is parent-child relationship, or in Oracle APEX terms, Master-Detail. So what you will do is make the team report the Master, and Players report the Detail.

I think there is a whole lot of documentation about this online so now that you know what you are looking for you should be able to figure things out. If you try and still cant make it work let me know.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.