SELEWORK

Returns workshop information in student schedules for courses with workshops.

Reporting Area(s)

Registrations, Workshops

Required Parameters

1. Course # (i.e. cocrse, wmcrse, rgcrse)
2. Name ID (i.e. nmid, rgid, wiid)
3. Condition to select specific workshops (i.e.: "subs(wicode,2,1= 'Q'" only returns workshops if the 2nd letter of the workshop code is "Q").
4. Field from the Workshop Master table to return ("wmtitle", "wicode")

--OR--Custom string: "wmcode"+" "+"wmtitle"

--OR-- Numeric return value:

1 = wmcode linefeed wmtitle

2 = wmcode linefeed wmtitle

3 = wmcode linefeed wmtitle linefeed wmloc

4 = wmcode linefeed wmtitle linefeed wmloc linefeed wmleader

8 = wmcode linefeed wmitle linefeed wmloc linefeed wmleader linefeed wmnote

9 = substring of wmcode starting at position 3 for 6 characters tab wmtitle linefeed wmloc

11 = Wmcode tab wmtitle

22 = wmcode tab wmtitle

33 =wmcode tab wmtitle tab wmloc

44 = wmcode tab wmtitle tab wmloc tab wmleader

88 = wmcode tab wmitle tab wmloc tab wmleader tab wmnote

99 = substring of wmcode starting at position 3 for 6 characters tab wmtitle tab wmloc

Optional Parameters

5. Logical .t. returns all workshops which meet condition, .f. returns only one
6. Logical .t. returns "Not Attending" if workshop does not meet criteria, .f. returns nothing if workshop does not meet criteria

Example(s)

SELEWORK(rgcrse,rgid," subs(wicode,1,1)='A'","wmtitle") returns Workshop Title if the workshop code begins with an A.

Notes

Workshops that fit the search criteria in Par. 3: adding Par 5 will return that field if the individual is enrolled in the workshop and return "Not Attending" if the individual is not enrolled.

Related Functions

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