GETTEST ​
Returns Credential records.
Reporting Area(s) ​
Names
Required Parameters ​
- Name ID (i.e nmid, rgid, pyid)
Optional Parameters ​
- Condition to return credential records, e.g. "tescore > 70".
- Condition to return fields, e.g. "trim(tetitle)+[ on ]+dtoc(tedate)". Default is "tetitle".
- Delimiter to place between fields (i.e.: " ", ",", Chr(9)).
Example(s) ​
GETTEST(nmid) returns the title of all credentials for an individual.
GETTEST(nmid,"tescore => 70") returns all credentials for an individual with a score of 70 or greater.
GETTEST(NMID,"tescore => 70","trim(tetitle)+[ on ]+dtoc(tedate)") returns all credentials for an individual with a score of 70 or greater in "[Credential Title] on [Credential Date]" format.