LISTSTUD ​
Returns list of individuals enrolled in course.
Reporting Area(s) ​
Courses, Registrations
Required Parameters ​
- Course #, (i.e. cocrse, rgcrse, pycrse)
Optional Parameters ​
- Numeric return value: (note: all but option 8 put a carriage return between names)
1= Name
2= Name City
3= Name Firm City
4= Name Firm City Day Phone
5= Name Day Phone Home Phone Email
7= Name Title Firm Address City St Zip Dayphone Homephone email
8= Name in comma separated list
9= Name Dayphone Cellphone RegistrationNote
10= Name Email
- Numeric return value: (passing nothing returns Sal. First MI. Last, Suffix)
0= First MI. Last, Suffix
1= First MI. Last
2= Last, First MI. Suffix
3= First Last
5= First MI (BadgeName) Last Suffix
- Logical .t. number names, .f. do not number names (Default)
- Condition to return individuals (i.e. "nmsex='F' "). Can use fields from Names or Register.
- Custom return string to define the fields and spacing between the fields. Can use fields from Names and/or Register. Override parameter 2.
Example(s) ​
LISTSTUD(cocrse) returns list of individuals registered in course (i.e. John Doe)
LISTSTUD(cocrse,2,2, .T.) returns numbered list of individuals and associated city registered in course (i.e. 1 Doe, John J Seattle)
LISTSTUD(cocrse,2,1,.t.,"nmsex='F'") returns list of individuals enrolled in course who are female
LISTSTUD(cocrse,,,.t.,,"namer(nmid,1)+' '+alltrim(nmspec)") returns list of individuals enrolled in course and their special needs
SQL Version
If you are running the SQL version, you will need to use LIKE for begins with conditions:
LISTSTUD(cocrse,2,1,.t.,"nmfeecat LIKEÂ 'Senior%'") returns list of individuals enrolled in course whose Fee Category value begins with 'Senior'.
A contains text condition example uses the % before and after the search term:
LISTSTUD(cocrse,2,1,.t.,"nmfeecat LIKEÂ '%Senior%'") returns list of individuals enrolled in course whose Fee Category value contains 'Senior'.
Notes ​
This function recognizes the value of the optional use of Sal., MI and Suffix as set up in your name entry preferences.