Can entries be unapproved after being approved?

Can entries be unapproved after being approved?

by Mary Legg -
Number of replies: 3

(moodle 1.9.6) Want to unapprove all entries in a glossary so that students can no longer view other student's entries

Teacher created a glossary, students made entries, teacher made comments including mark. All entries were then approved, but teacher has decided that she doesn't want students to be able to view the entries and comments except on their own entry.

We had thought of making each student in their own individual group, but there are 92 students.  Also thought of copying the glossary into a new glossary, which I think would lose the comments but we could copy them individually from the original glossary.  But hoping someone out there has a smarter idea?

Any ideas gratefully appreciated.  

Average of ratings: -
In reply to Mary Legg

Re: Can entries be unapproved after being approved?

by Joseph Rézeau -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers Picture of Translators

Hi Mary,

Unfortunately there is no way to "un-approve" approved student entries in the glossary through Moodle's teacher/admin interface. However, if you have an access to your moodle site database, you can easily do it as follows. As usual, please backup your glossary before you do anything you might regret.wink

  1. identify the glossary instance's course-module id ; it appears when you view a glossary, something like "/moodle/mod/glossary/view.php?id=27"
  2. Supposing that the glossary you want to update has that course-module id = 27, using phpMyAdmin or similar tool, type the following sql request:

    UPDATE mdl_glossary_entries SET approved = '0' WHERE glossaryid = (SELECT instance AS glossaryinstance from mdl_course_modules WHERE id = '27') AND mdl_glossary_entries.teacherentry = 0

When you view your glossary after the request has been executed you will notice that the "Waiting approval (99)" message appears again at the top right of your glossary view window.

The reason for the mdl_glossary_entries.teacherentry = 0 condition in the sql request is that we do not want teacher entries to be unapproved, only those entered by the students, of course!

Hope that helps,

Joseph


Average of ratings: -
In reply to Mary Legg

Re: Can entries be unapproved after being approved?

by Joseph Rézeau -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers Picture of Translators

"Teacher created a glossary, students made entries, teacher made comments including mark. All entries were then approved, but teacher has decided that she doesn't want students to be able to view the entries and comments except on their own entry."

Why did the teacher approve the entries in the first place, then changed her mind?thoughtful

Average of ratings: -
In reply to Joseph Rézeau

Re: Can entries be unapproved after being approved?

by Mary Legg -
Many thanks for your helpful reply which worked perfectly. This will certainly encourage me to refer to moodle.org more often from now on, rather than battle on alone.

Basically, why we did it is because the moodle support people hadn't used glossary much and didn't realise that the teacher wouldn't want students to see her comments to other students. The moodle support guys approved the entries, and then the teacher didn't like it.
Average of ratings: -