I am wondering if it is possible to link two tables together in the following manner.
I have a table ('Detail Table') setting out details of a specific event. The table contains the following columns:
1. Unique ID of the event (note: this value will be the same for the entire event, and thus each row has the same value. This column may be hidden for the user)
2. Attendee Name (each registered attendee will be registered in an individual cell. Thus, if there are 5 registered attendees, there would be 5 rows in this table).
3. Attendee Profession (for each attendee, this will show his/her profession. For simplicity, assume this is based on an exhaustive list of 10 potential professions).
I have a second table ('Overview Table) setting out a list of events. This table will thus reflect a list of events, with each event having its own 'Detail Table' with more detailed information on attendees.
The 'Overview Table' contains the following columns:
1. Unique ID of the event (thus, each row will show 1 event with a unique ID)
2. Date of the event (thus, each row will show a single date corresponding to the event in that row)
3. Professions of attendees attending.
- This cell should function such that it takes the values from the corresponding 'Detail Table' in the column 'Attendee Profession' for all attendees to that event, and show them in a single cell. So, for example, if the 'Detail Table' for this event would show 3 attendees, one of which is a 'performer', one of which is a 'teacher' and one of which is a 'lawyer', this cell should show "performer, teacher, lawyer".
- It should also be possible to conduct a search in the 'Overview Table' based on profession (with multi-select boxes). I.e., if the user would search for "teacher" it would show all rows in which a teacher attends (irrespective of whether other professions also attend).
Is it possible to do this in wpDataTables, and if so, how?
I am wondering if it is possible to link two tables together in the following manner.
I have a table ('Detail Table') setting out details of a specific event. The table contains the following columns:
1. Unique ID of the event (note: this value will be the same for the entire event, and thus each row has the same value. This column may be hidden for the user)
2. Attendee Name (each registered attendee will be registered in an individual cell. Thus, if there are 5 registered attendees, there would be 5 rows in this table).
3. Attendee Profession (for each attendee, this will show his/her profession. For simplicity, assume this is based on an exhaustive list of 10 potential professions).
I have a second table ('Overview Table) setting out a list of events. This table will thus reflect a list of events, with each event having its own 'Detail Table' with more detailed information on attendees.
The 'Overview Table' contains the following columns:
1. Unique ID of the event (thus, each row will show 1 event with a unique ID)
2. Date of the event (thus, each row will show a single date corresponding to the event in that row)
3. Professions of attendees attending.
- This cell should function such that it takes the values from the corresponding 'Detail Table' in the column 'Attendee Profession' for all attendees to that event, and show them in a single cell. So, for example, if the 'Detail Table' for this event would show 3 attendees, one of which is a 'performer', one of which is a 'teacher' and one of which is a 'lawyer', this cell should show "performer, teacher, lawyer".
- It should also be possible to conduct a search in the 'Overview Table' based on profession (with multi-select boxes). I.e., if the user would search for "teacher" it would show all rows in which a teacher attends (irrespective of whether other professions also attend).
Is it possible to do this in wpDataTables, and if so, how?
Thank you!