Gradebook score provider and Content Handler counting (OpenDB)

Document created by bs28666 on Oct 17, 2016
Version 1Show Document
  • View in full screen mode

This query gives a list of all gradebook score providers (and their item counts) for all courses that match the pattern '%-20168'

SELECT sp.name, gm.score_provider_handle, count(gm.pk1)
FROM bb_bb60.course_main cm
INNER JOIN bb_bb60.gradebook_main gm ON cm.pk1 = gm.crsmain_pk1
LEFT JOIN bb_bb60.score_provider sp ON gm.score_provider_handle = sp.handle
WHERE cm.course_id LIKE '%-20168' 
GROUP BY sp.name, gm.score_provider_handle
ORDER BY count(gm.pk1) DESC;

 

This query gives a list of all content handlers (and their item counts) for all courses that match the pattern '%-20168'

SELECT ch.name, cc.cnthndlr_handle, count(cc.pk1)
FROM bb_bb60.course_main cm
INNER JOIN bb_bb60.course_contents cc ON cm.pk1 = cc.crsmain_pk1
LEFT JOIN bb_bb60.content_handlers ch ON cc.cnthndlr_handle = ch.handle
WHERE cm.course_id LIKE '%-20168'
GROUP BY ch.name, cc.cnthndlr_handle
ORDER BY count(cc.pk1) DESC;

 

In both queries, you will want to change '%-20168' to match whatever pattern you'd like to match against for the course_id

Attachments

    Outcomes