~[wc:commonscripts] ~[wc:admin_header_css] Start Page > Reports > Run Reports > ~[text:psx.htmlc.admin.shoutout.report.title] ~[wc:admin_navigation_css]

~[text:psx.htmlc.admin.shoutout.report.title]~[if#sch.is.a.school] - ~(schoolname) ~[text:psx.htmlc.admin.shoutout.report.Recipients][/if#sch]

~[if#page.~(gpv.startdate)=]
~[text:psx.htmlc.admin.shoutout.report.Select_report_criteria]
[else#page]
~[text:psx.htmlc.admin.shoutout.report.Current_Row_Count]    ~[text:psx.htmlc.admin.shoutout.report.Run_on] ~(date.information;type=today)
~[tlist_sql; SELECT u_shoutouts.id, '~(gpv.startdate;sqlText)' startdate, '~(gpv.enddate;sqlText)' enddate, to_char(u_shoutouts.shout_date, 'MM/DD/YYYY'), recipient.first_name, recipient.last_name, author.first_name, author.last_name, case when u_shoutouts.shout_anon = 1 then chr(60) || 'div class="sentAnonDiv"' || chr(62) || chr(40) || '~[text:psx.htmlc.admin.shoutout.report.sent_anonymously]' || chr(41) || chr(60) || '/div' || chr(62) end shout_anon, listagg(case when schoolstaff.schoolid = 0 then '~[text:psx.htmlc.admin.shoutout.report.District]' else schools.abbreviation end, ', ') within group (order by schools.abbreviation), SUBSTR(u_shoutouts.shout_entry, 1, ~[if#sum.~[displaypref:shout_summary]=]100[else#sum]~[displaypref:shout_summary][/if#sum]), case when LENGTH(u_shoutouts.shout_entry) > ~[if#sum.~[displaypref:shout_summary]=]100[else#sum]~[displaypref:shout_summary][/if#sum] then chr(60) || 'a class="showMore button mini" title="~[text:psx.htmlc.admin.shoutout.report.Show_full_entry]"' || chr(62) || '~[text:psx.htmlc.admin.shoutout.report.More]' || chr(60) || '/a' || chr(62) end, case when LENGTH(u_shoutouts.shout_entry) > ~[if#sum.~[displaypref:shout_summary]=]100[else#sum]~[displaypref:shout_summary][/if#sum] then chr(60) || 'div class="hideDiv"' || chr(62) || u_shoutouts.shout_entry || chr(60) || '/div' || chr(62) end FROM u_shoutouts LEFT OUTER JOIN users author ON u_shoutouts.shout_author = author.dcid LEFT OUTER JOIN users recipient ON u_shoutouts.shout_recipient = recipient.dcid LEFT OUTER JOIN schoolstaff ON recipient.dcid = schoolstaff.users_dcid LEFT OUTER JOIN schools ON schoolstaff.schoolid = schools.school_number WHERE u_shoutouts.shout_date between to_date('~(gpv.startdate;sqlText)','MM/DD/YYYY') and to_date('~(gpv.enddate;sqlText)','MM/DD/YYYY') AND schoolstaff.status = 1 ~[if#dis.district.office] ~[if#sch.~(gpv.schoolnum;sqlText)=][else#sch] AND schoolstaff.schoolid = ~(gpv.schoolnum;sqlText) [/if#sch] [/if#dis] ~[if#sch.is.a.school] AND schoolstaff.schoolid = ~(curschoolid) [/if#sch] GROUP BY u_shoutouts.id, to_char(u_shoutouts.shout_date, 'MM/DD/YYYY'), recipient.first_name, recipient.last_name, author.first_name, author.last_name, case when u_shoutouts.shout_anon = 1 then chr(60) || 'div class="sentAnonDiv"' || chr(62) || chr(40) || '~[text:psx.htmlc.admin.shoutout.report.sent_anonymously]' || chr(41) || chr(60) || '/div' || chr(62) end, SUBSTR(u_shoutouts.shout_entry, 1, ~[if#sum.~[displaypref:shout_summary]=]100[else#sum]~[displaypref:shout_summary][/if#sum]), case when LENGTH(u_shoutouts.shout_entry) > ~[if#sum.~[displaypref:shout_summary]=]100[else#sum]~[displaypref:shout_summary][/if#sum] then chr(60) || 'a class="showMore button mini" title="~[text:psx.htmlc.admin.shoutout.report.Show_full_entry]"' || chr(62) || '~[text:psx.htmlc.admin.shoutout.report.More]' || chr(60) || '/a' || chr(62) end, case when LENGTH(u_shoutouts.shout_entry) > ~[if#sum.~[displaypref:shout_summary]=]100[else#sum]~[displaypref:shout_summary][/if#sum] then chr(60) || 'div class="hideDiv"' || chr(62) || u_shoutouts.shout_entry || chr(60) || '/div' || chr(62) end ORDER BY 1 desc ;nonemessage=] [/tlist_sql]
~[text:psx.htmlc.admin.shoutout.report.Date] ~[text:psx.htmlc.admin.shoutout.report.Author] ~[text:psx.htmlc.admin.shoutout.report.Recipient] ~[text:psx.htmlc.admin.shoutout.report.Recipient_schools] ~[text:psx.htmlc.admin.shoutout.report.Shout_Out]
~[text:psx.htmlc.admin.shoutout.report.No_Records_Found]
~(shout_date) ~(author_first) ~(author_last)~(shout_anon) ~(recipient_first) ~(recipient_last) ~(recipient_schools) ~(summary;ReplaceCRLFWithBR) ~(morebutton)~(fullentry;ReplaceCRLFWithBR)
[/if#page] ~[wc:admin_footer_css]