GRABREG
Returns specified field if student has taken a course which meets stated condition.
Reporting Area(s)
Names, Registrations
Required Parameters
- Name ID (i.e. nmid, rgid, pyid)
- Condition to return value. The condition must be based on the Register table (i.e. "rgstatus = 'Guest')
- Field from Register table to return (e.g. rggrade, rgfeedesc)
Optional Parameters
- Delimiter to place between registration records (i.e. " ", ",", CHR(13) Carriage Return (default) )
- Character return value if no registration records meet condition (parameter 2). Default is 'NONE'.
Example(s)
GRABREG(rgid,"'MGT101'$rgcrse",'rggrade','*') .. returns all grades from courses with MGT101 in course, separated by '*' returns NONE if none found.
GRABREG(nmid,"'MGT101'$rgcrse",'rggrade','*','NO RECORDS') .. returns all grades from courses with MGT101 in course code, separated by '*' returns NO RECORDS if none found.