SELEWORK2

Returns workshop information in student schedules for courses with workshops with the option to return a fixed length field.

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. Fields from the Workshop Master table to return ("wmtitle", "wicode")
5. Numeric return value: minimum size of field to return. If no parameter entered, defaults to size of first workshop returned in field.

Optional Parameters

None

Example(s)

SELEWORK2(rgcrse,rgid," subs(wicode,1,1)='A'","wmtitle",60) returns Workshop Title if the workshop code begins with an A with the field padded to 60 characters

Related Functions

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