Content Comparison

...

1. Right-click the Activity Completion Domain and select Edit. The Edit Domain page opens. 
2. Underneath the Domain Design heading, click the Edit withDomain Designer link. The Domain Designer opens to the Display tab.
3. Navigate to the Derived Tables tab.
4. In the Query ID field, enter the name "proper_act_name".

5. 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 = '/*NAME*/' union

   
   Note the two variables highlighted in this select statement:

   •  /*LMS TABLE*/ : In place of this variable, insert the proper LMS module table name. For example, 'mdl_lesson' or 'mdl_quiz'.

   • /*NAME*/ : In place of this variable, insert the name of the Activity. For example, 'lesson' or 'quiz'.

6. To start, you can begin by entering the following sample Derived Table. You will likely find this series of select statements to miss some of your custom modules and name several that you do not use. Enter the following query into the Query field:
   
   

   Code Block
   language sql theme Eclipse linenumbers true
   select m.id as moduleid, m.name as moduletype, t.id as instanceid, t.name as instancename, t.course as courseid from mdl_assign t join mdl_modules m on m.name = 'assign' union select m.id as moduleid, m.name as moduletype, t.id as instanceid, t.name as instancename, t.course as courseid from mdl_assignment t join mdl_modules m on m.name = 'assignment' union select m.id as moduleid, m.name as moduletype, t.id as instanceid, t.name as instancename, t.course as courseid from mdl_book t join mdl_modules m on m.name = 'book' union select m.id as moduleid, m.name as moduletype, t.id as instanceid, t.name as instancename, t.course as courseid from mdl_chat t join mdl_modules m on m.name = 'chat' union select m.id as moduleid, m.name as moduletype, t.id as instanceid, t.name as instancename, t.course as courseid from mdl_choice t join mdl_modules m on m.name = 'choice' union select m.id as moduleid, m.name as moduletype, t.id as instanceid, t.name as instancename, t.course as courseid from mdl_data t join mdl_modules m on m.name = 'data' union