example_competencyframeworks_configurable_reports.sql

SELECT  ccc.id, ccc.courseid, ccc.competencyid, cf.shortname as 'referentiel', cf.idnumber as 'framework Id', c.fullname as 'cours', comp.shortname
FROM  prefix_competency_coursecomp ccc
INNER JOIN prefix_course AS c ON c.id = ccc.courseid
INNER JOIN prefix_competency AS comp ON comp.id = ccc.competencyid
INNER JOIN prefix_competency_framework AS cf ON cf.id = comp.competencyframeworkid
JOIN prefix_course_categories cc ON c.category = cc.id
WHERE 1=1
%%FILTER_COMPETENCYFRAMEWORKS:cf.id%%
%%FILTER_SUBCATEGORIES:cc.path%%
%%FILTER_STARTTIME:c.startdate:>=%% %%FILTER_ENDTIME:c.startdate:<=%%