Skip to content

GRPSTUD

Returns list of registrations in a given group.

Reporting Area(s)

Invoices, Registrations

Required Parameters

  1. Group ID (rggroupid, pypayid)

Optional Parameters

  1. Numeric return value (default is Name only):

1= Name

2= Name, ID

3= Name, Course Title

4= Name, ID Course Title

OR--User defined character string (i.e. "nmname3+', '+nmname1+' '+cocrsenm")

  1. Logical .t. number names, .f. do not number names (Default)
  2. Condition to return individuals (i.e. "nmsex='F' ")
  3. Extra field to include (i.e. "nmcode1'')
  4. Custom Return String (i.e. ")"namer(nmid)+' '+nmcode1

Example(s)

GRPSTUD(pypayid) returns list of individuals in registration group (i.e. John Doe)

GRPSTUD(pypayid,2,.T.) returns numbered list of individuals with ID in registration group (i.e. John Doe, X00-01-1111)

GRPSTUD(rggroupid,3,.t.,"nmsex='F'") returns list of individuals in registration group who are female

GRPSTUD(rggroupid,3,.t.,"nmsex='F'","nmcode1","namer(nmid)+' '+nmcode1") returns list of individuals in registration group who are female with name and value in nmcode1 field

Notes

This function excludes registrations marked as billing records, canceled, waitlisted, and deleted records.

GRPGTBAL
GRPGTDUE
GRPGTPAID
LISTSTUD
RCTTPAY