...
Now that the tables have been created you will need to add join them into the data source so they are available when using the Ad Hoc View builder.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.
11. Navigate to the Display tab.
12. In the Resources panel, select to View as: Join Tree.
13. Expand JoinTree_1, then expand the
...
event_fields / asset_fields / room_fields / signup_fields /
...
user_
...
cancellation_fields / event_cancellation_fields table:
13. Select the relevant field(s) and drag it into the appropriate set in the Sets and Items panel.
14. Click the OK button to save your changes in the Data Source Designer and return to the Edit Data Source page.
15. Under the Required Information heading, rename the Course Enrollments Data Source in the Name field, in order to avoid confusing it with the Public Course Enrollments Data Source. We will call this Data Source the "CompanyABC Course Enrollments Data Source".
16. To save your changes to the Data Source, click the Submit button