Assume Business Logic:
- Sponsoring Organizations list Opportunities
- Academic Organization Can see Opportunities, and submit proposals to opportunities
Data Structure:
- I have a object of institutions with each one listed as a “academic Institution” and/or a “Sponsoring Organization”.
- Then I have an object of opportunities.
- Each opportunity is associated with a Sponsoring Organization.
- In the institutions object, each Sponsoring Organization has a list of opportunities.
Problem
Historically we every opportunity is able to be seen by every Academic Organization. But going forward, there will be opportunities only open to select organizations. What is the best way to setup this structure?
-
Was thinking in the opportunities opject to create 2 fields, 1) Open to All? (yes/no), and if no, they have 2) a list of selected “academic Institution”.
-
This can be done, I just don’t know exactly how to write the query for the repeating group tables.
Show me all opportunities that are either Open to All Yes, and include current users institution (academic Institution).