Adding [teacher_name] to EPP termgrades.html

Submitted by jkrainak on Tue, 10/09/2012 - 8:41am

Forums:

I was attempting to do this by adding a concat to the original sql:

SELECT CONCAT(course_name, teacher_name) wholename, ~(v.sql)' ' grades....

and changing the references to it accordingly:

~(wholename)~[guv:test]

I also tried:

SELECT course_name || teacher_name

Any thoughts?

jkrainak

Tue, 10/09/2012 - 9:53am

Figured this one out - it had to do with me not adding the teacher_name field to the GROUP BY portion of the SQL string:

~[tlist_sql;
SELECT case course_name ||' ('||teacher_name||')' ,~(v.sql)'' grades from storedgrades where studentid=~(curstudid) and termid between ~(v.histyearid)00 and ~(v.histyearid)99 group by course_name,teacher_name order by upper(course_name);alternatecolor]

dpresident

Wed, 10/31/2012 - 7:31am

I tried modifying the tlist-sql as you indicated but it doesn't work for me. I would appreciate it if you could please confirm what changes you made to the EPP termgrades.html page.

Subscribe to Comments for "Adding [teacher_name] to EPP termgrades.html"