SHOWTEST ​
Returns Credential records.
Reporting Area(s) ​
Names
Required Parameters ​
- Name ID (i.e nmid, rgid, pyid)
Optional Parameters ​
- Numeric return value:
0= Code, title, type, credits, score (Default)
1= Date, title
2= Date, 40 characters of title, type, credits, score
3= Code, 40 characters of title, date, score
OR--custom return string enclosed in quotations, e.g. " 'Code: '+Tecode+', Course Name:'+subs(tetitle,1,25)+', Grade '+Tescore"
- Condition to return credential records, e.g. "tescore > 70".
- Sort order. E.g. "tedate,tetitle". Default is tedate.
- Logical .t. returns credentials in html format (for email purposes).
- Custom return message. Defaults to "### No Credential Records Found ###
Example(s) ​
SHOWTEST(nmid) returns all credentials for an individual.
SHOWTEST(nmid, " 'Code: '+Tecode+', Course Name:'+tetitle+', Grade" '+Tescore") returns code, title and score of all credentials for an individual.
SHOWTEST(nmid,0,"tescore => 70","tedate,tetitle") returns all credentials for an individual with a score of 70 or greater, sorted in date,title order.