GRABREG

Returns specified field if student has taken a course which meets stated condition.

Reporting Area(s)

Names, Registrations

Required Parameters

1. Name ID (i.e. nmid, rgid, pyid)
2. Condition to return value. The condition must be based on the Register table (i.e. "rgstatus = 'Guest')
3. Field from Register table to return (e.g. rggrade, rgfeedesc)

Optional Parameters

4. Delimiter to place between registration records (i.e. " ", ",", CHR(13) Carriage Return (default) )
5. 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.

Related Functions

ADDREG