...
Now that the tables have been created you will need to join them into the data source so they can be used by reports.
10. Navigate to the Joins tab and add the following joins according to the derived tables and custom fields that you would like to add.
Left Table | Field | Join Type | Right Table | Field |
---|---|---|---|---|
mdl_facetoface_sessions | id | LEFT OUTER | event_fields | session_id |
mdl_facetoface_asset | id | LEFT OUTER | asset_fields | asset_id |
mdl_facetoface_room | id | LEFT OUTER | room_fields | room_id |
mdl_facetoface_signups | id | LEFT OUTER | signup_fields | Signup_id |
mdl_facetoface_signups | id | LEFT OUTER | user_cancellation_fields | signup_id |
mdl_facetoface_sessions | id | LEFT OUTER | event_cancellation_fields | session_id |
Finally we need to add the custom fields to the Data Source so they are available with the Ad Hoc View builder.
...