Version 1.3
Description
This plugin adds a student track column to the PowerTeacher and Sub class attendance pages.
This page fragment can easily be modified to display different or additional field values.
Example 1
To add the team field.
$j(function(){
var track = [~[tlist_sql;
SELECT cc.id, s.track, s.team
FROM cc
INNER JOIN students s ON (cc.studentid = s.id)
WHERE sectionid = ~(gpv.sectionid;sqlText)]
{"id":"ccid_~(id)","track":"~(track;t) / ~(team;t)"},
[/tlist_sql]];
$j("table#attendance-table colgroup:first col:first").after('');
$j("table#attendance-table tr:first th:first").after('Track / Team');
for(i=0;i' + track[i].track + '');
}
})
Example 2
To Decode the Track values.
$j(function(){
var track = [~[tlist_sql;
SELECT cc.id, decode(s.Track,'A','Navy','B','Gold','C','All Virtual','') Track
FROM cc
INNER JOIN students s ON (cc.studentid = s.id)
WHERE sectionid = ~(gpv.sectionid;sqlText)]
{"id":"ccid_~(id)","track":"~(Track)"},
[/tlist_sql]];
$j("table#attendance-table colgroup:first col:first").after('');
$j("table#attendance-table tr:first th:first").after('Track / Cohort');
for(i=0;i' + track[i].track + '');
}
})
PSCB Development Team
Rob Staats
Manjit Basra
Michael Moore
Version Info
1.0 (2020-09-13)
- Initial Release
1.1 (2020-09-24)
- Added student track to the sub class attendance page.
1.2 (2020-10-06)
- Corrected Fill Code issue. Changed Track display format.
1.3 (2020-11-04)
- Student names containing a apostrophe now display correctly in the sub portal
- Tracks now display correctly in the sub portal for students with identical names.
Powerschool Compatible Versions
19.x, 20.x
Additional Plugin Requirement
The following PSCB plugins should be installed prior to the installation of this reports bundle.
PSCB - Base Resources
Installation
Install in System > System Settings > Plugin Management Configuration
Do not unzip the plugin. Install the entire zip file. Be sure to enable the plugin once it's installed.
If you are updating, you can now click on the Plugin name and then use the Update button, and then browse to the new file and click Submit and it will then load the update and then ask you to enable it.
Instructions
Login to PowerTeacher start page.
Click on the chair icon for a selected class.
Comments
dbridgeforth
Tue, 09/15/2020 - 7:08am
Permalink
So if I wanted to add a
So if I wanted to add a decode to this statement how could I update the header?
~(decode;~([students]Track);A;Navy;B;Gold;C;All Virtual)
$j(function(){
var track = [~[tlist_sql;
SELECT cc.id, s.track
FROM cc
INNER JOIN students s ON (cc.studentid = s.id)
WHERE sectionid = ~(gpv.sectionid;sqlText)]
{"id":"ccid_~(id)","track":"~(track;t)"},
[/tlist_sql]];
$j("table#attendance-table colgroup:first col:first").after('');
$j("table#attendance-table tr:first th:first").after('Track / Cohort');
for(i=0;i' + track[i].track + '');
}
})
Dana Bridgeforth
PSCB
Wed, 09/23/2020 - 2:25pm
Permalink
So if I wanted to add a decode - Reply
Replace the current script with the following.
$j(function(){
var track = [~[tlist_sql;
SELECT cc.id, decode(s.Track,'A','Navy','B','Gold','C','All Virtual','') Track
FROM cc
INNER JOIN students s ON (cc.studentid = s.id)
WHERE sectionid = ~(gpv.sectionid;sqlText)]
{"id":"ccid_~(id)","track":"~(Track)"},
[/tlist_sql]];
$j("table#attendance-table colgroup:first col:first").after('');
$j("table#attendance-table tr:first th:first").after('Track / Cohort');
for(i=0;i' + track[i].track + '');
}
})
--
Rob Staats
PSCB Development
dbridgeforth
Tue, 09/15/2020 - 7:10am
Permalink
Footer
classattendance.PSCB_Track.content.footer.txt
See above questions..sorry for that mistake
Dana Bridgeforth
PSCB
Tue, 09/15/2020 - 5:13pm
Permalink
So if I wanted to add a - Reply
This page fragment does not support "Decode" statements.
--
Rob Staats
PSCB Development
jwydra
Thu, 09/17/2020 - 9:54am
Permalink
Enhancement Request
This is beautiful!!
Is there any way that this could be added to the sub portal as well?
PSCB
Thu, 09/17/2020 - 6:04pm
Permalink
Enhancement Request - Reply
Thank you for your request. We are not doing sub portal customizations at this time. I will add this request to the PSCB Enhancement list.
--
Rob Staats
PSCB Development
jpayne
Wed, 09/23/2020 - 2:07pm
Permalink
So how are subs supposed to
So how are subs supposed to know what track the student is on?
Julie Payne
Falmouth Public Schools
PSCB
Thu, 09/24/2020 - 5:59pm
Permalink
So how are subs supposed to - Reply
Version 1.1 now adds the Student track Sub Class Attendance page.
--
Rob Staats
PSCB Development
ablazey
Fri, 10/02/2020 - 9:37am
Permalink
Not seeing Group By Option
Hi,
I plugged this in and Im not seeing the group by option, any troubleshooting suggestions? Thanks!
Alison Blazey
ablazey@ehtp.org
Data and Systems Manager
KIPP NYC College Prep
PSCB
Fri, 10/02/2020 - 11:38am
Permalink
Not seeing Group By Option - Reply
The Group Option is not a PSCB Customization.
The Group Option is a new feature in included in PS version 20.4.3.
If you have this version installed, you will see a Group By Cohort/Track option at the top of the Class Attendance page.
--
Rob Staats
PSCB Development