adaptiveteam / adaptive

Umbrella repo for Adaptive library code
2 stars 0 forks source link

Generate comprehensive feedback report for HR #257

Open Primetalk opened 4 years ago

Primetalk commented 4 years ago

Here is the SQL:

SELECT source.display_name             AS "Source",
       target.display_name             AS "Target",
       user_feedback.confidence_factor AS "Confidence",
       competency.name                 AS "Competency",
       user_feedback.quarter,
       user_feedback.year,
       user_feedback.feedback          AS "Feedback"
FROM user_feedback,
     user AS source,
     user AS target,
     competency
WHERE user_feedback.platform_id = ?
  AND user_feedback.quarter = ?
  AND user_feedback.year = ?
  AND source.id = user_feedback.source
  AND target.id = user_feedback.target
  AND user_feedback.competency_id = competency.id
ORDER BY source, target
sunnylbk commented 4 years ago

@ctcreel update on this?