PACKAGES ​
For use with Course Packaging Module - displays information about child courses in the Course package (as set on the Parent Course).
Reporting Area(s) ​
Courses
Required Parameters ​
- Course # (i.e. cocrse).
Optional Parameters ​
- Character return value: field(s) from Course table to return. Note: if using a function to format a field, you must use the AS clause and specify a variable name (see nicedate() expression in example 2 below).
- Custom Sort Order (e.g. "cobegdate,cocrsenm"). Default is Course Number (i.e. cocrse).
Example(s) ​
PACKAGES(cocrse) returns the course number of all Child courses in the course package. Course codes are listed on separate lines.
PACKAGES(cocrse,"cocrsenm,nicedate(cobegdate,coenddate,0,40) as dates") returns title and dates of all Child courses in the course package. Fields are separated by the pipe [ | ] character (e.g. Mastering Student Manager 8.0|September 13-14, 2011), with courses on separate lines.
PACKAGES(cocrse,"cocrsenm,nicedate(cobegdate,coenddate,0,40) as dates","cobegdate,cocrsenm") returns title and dates of all Child courses in the course package, sorted by begin date,title. Fields are separated by the pipe [ | ] character (e.g. Mastering Student Manager 8.0|September 13-14, 2011), with courses on separate lines.