...
- Right-click the Activity Completion Domain and select Edit. The Edit Domain page opens.
- Underneath the Domain Design heading, click the Edit with Domain Designer link. The Domain Designer opens to the Display tab.
- Navigate to the Derived Tables tab.
- In the Query ID field, enter the name "proper_act_name".
In the Query field, you will need to enter a series of select statements based on the following formula:
Code Block language sql theme Eclipse select m.id as moduleid, m.name as moduletype, t.id as instanceid, t.name as instancename, t.course as courseid from /*LMS TABLE*/ t join mdl_modules m on m.name = 'assign' union