I have three collections as follows: EVENTS - List of events EVENT_DETAIL - References EVENTS - List of event detail needs VOLUNTEERS - References EVENT_DETAIL - List of people assigned to tasks/needs
I have a registration process working, filtering by EVENT, then EVENT_DETAIL along with code. What I need help with please is displaying the VOLUNTEERS collection in a table element by EVENTS, without displaying the specific EVENT_DETAILS. I want the user to be able to select an EVENT and see all the VOLUNTEERS associated.
Here's an example of what I would like to accomplish if using sql: select ed.descr, v.first_name, v.last_name, v.email
from events e,
where e.pe_title = ed.pe_title
and ed.ped_title = v.ped_title
and e.pe_title = <varEventName> Thank you in advance!