LISTWORK

Returns specified workshop information from individual's registration.

Reporting Area(s)

Registrations

Required Parameters

1. Course # (cocrse, rgcrse, pycrse)
2. Name ID (nmid, rgid, pyid)

Optional Parameters

1. Numeric return value:

1= Date, Title

2= Date, Title, Hours

3= Title, Date

4= Code, Title

5= Code, Title

6= Code, Title, Date, Location, Time

7= Date, Title, Location, Time

8= Title, Leader, CEUs, Grade

Or -- User defined character string (i.e. "DTOC(wmdate)+' '+trim(wmtitle)" )

3. Delimiter to place between workshop records. Default is Carriage return (i.e. chr(13) ).
4. Sort Order. Fields from WKSHPMST or WKSHPIND may be used (i.e. "wmcode", "wmdate"). Default is title.
5. Condition to return workshop records. Fields from WKSHPMST or WKSHPIND may be used (i.e. "wmcode='A' "). Default is ALL workshops not marked for deletion.

Example(s)

LISTWORK(rgcrse,rgid) Returns title of all workshops individual is enrolled in.

LISTWORK(rgcrse,rgid,"DTOC(wmdate)+' '+trim(wmtitle)",chr(13),"wmdate") Returns workshop date and title, sorted by workshop date.

LISTWORK(rgcrse,rgid,3,chr(13),"wmdate","wmcode='A' ") Returns title and date of all workshops where the code begins with 'A', sorted by workshop date.

Related Functions

ADDWKCODE
CTWORK
CURSWORK
CUSTWKCD
LISTWORK
QUIKWORK
SELEWORK
SELEWORK2
SHOWWKMS
SHOWWORK
STAMPWORK
SUMWORK