Some background
I have a table that contains events that people can register to attend, call this the Events table. I have another table where I put all the registrations, call this the Registrations table. In the Events table on each event (row) I have a relation column that references all the registrations associated with that particular event.
Csv file generation only allows me to dump a whole table.
What I want to do
I want to generate a csv file of an all the registrations of a particular event. So I either want
- to dump a csv of everything in the relation column in the Events table
- be able to put a condition on the csv file generation that only causes some of the rows in the Registrations table to be written
Or
Is there something else I can do?