SHOUPCLSREC ​
For Email Receipts: returns a list of upcoming courses, excluding the course(s) in which student is enrolled.
Reporting Area(s) ​
Email Receipts
Required Parameters ​
- Numeric Return Value: number of days, based on course begin date, for courses to be returned (e.g. 30 would return courses beginning within the next 30 days).
- chkGroup variable to exclude courses from the current transaction in the upcoming list.
Optional Parameters ​
- Character return string: user defined string to return fields (e.g. "dtoc(cobegdate)+' '+alltrim(cocrsenm)". If nothing is entered, the default is Cocrse+" "+SUBSTR(cocrsenm,1,45)+" "+DTOC(cobegdate)
- Condition to return courses based on field from Course table (e.g. "cowebreg>2").
Example(s) ​
SHOUPCLSREC(30,chkGroup) returns course number, course title and begin date of all courses that begin within the next 30 days.
SHOUPCLSREC(30,chkGroup,"dtoc(cobegdate)+' '+alltrim(cocrsenm)+crlf") returns course begin date and title, for all courses that begin within the next 30 days.
SHOUPCLSREC(30,chkGroup,"dtoc(cobegdate)+' '+alltrim(cocrsenm)+crlf","cowebreg>2") returns course begin date and title, for all courses that begin within the next 30 days where the ACEweb Publish Properties is set to one of the Publish options).
Notes ​
This function MUST be placed in the Email Footer of the email template--AND--you must use the Body Coding Rules to build the footer. For example:
