Cleaning Up Blocks in Courses

Janelle Cleaves

• March 24, 2025 18:15

Hello all,

In light of 4.4 MP2 incorporating the block drawer in Snap, I'm wanting to start cleaning up our blocks. With them getting shuffled to the bottom of the Course Dashboard, most instructors don't pay attention to them leading to them piling up over time. I tried creating a report in the Open Reports Engine and Custom Reports but couldn't find a way to pull the blocks in there. I've run SQL reports before, but I have zero idea how to actually write one. Anybody have any ideas?

Best,

Janelle

1

• 

  Jason Rodgers

  • March 28, 2025 18:29

  Here is something that might help

  SELECT 
  BI.Blockname, 
  C.instanceid AS CourseID, 
  CO.fullname,
  concat('https://YOURURL/course/view.php?id=',C.instanceid) as Directlink
  FROM mdl_block_instances BI
  LEFT JOIN mdl_context C ON C.id=BI.parentcontextid
  LEFT JOIN mdl_course CO ON CO.id=C.instanceid
  WHERE CO.visible=1

  1
• 

  Janelle Cleaves

  • April 07, 2025 18:13

  Dear Jason,

  I meant to respond to this here. Thank you! That works great.

  0

Please sign in to leave a comment.