Select

Syntax

Select              field_name
operator            value
And
Or
Select Event        event_name
operator            value
Selected            field_name
Selected Message    message
Selected Value      source_field
Continue

Parameters

• field_name: The name of the database field to filter on. Can also be the special value Record Number.
• event_name: The name of an event to filter on (e.g., Start, FINISH).
• operator: The comparison operator. Allowed values:

Operator	Alternate	Meaning
<	LT	Less than
<=	LE	Less than or equal to
=	EQ	Equal to
>=	GE	Greater than or equal to
>	GT	Greater than
<>	NE	Not equal to
Starts with	SW	Starts with these characters
Contains		Contains this string

• value: The value to compare against. For date fields, use YYYYMMDD format regardless of the date format set in entries.ini.
• Selected field_name: Marks a field in the database based on the selection criteria.
• Selected Message message: Optional. Specifies the text to place in the selected field. Defaults to X if omitted. If used with no argument, clears the field.
• Selected Value source_field: Copies the contents of source_field into the field specified by Selected.
• Continue: After a Selected command executes, processing normally stops. Continue allows further processing (e.g., sending email after marking a field).

Description

Filters which entrants are included in a listing or process based on specified criteria.

warning

Do not confuse Select with Select Timing. Select is used in listings to determine which entries to print. Select Timing is for recording times at the finish line.

Remarks

And / Or logic

• And connects two selection criteria where both conditions must hold.
• Or connects two criteria where either condition can hold.
• You can have a series of Or commands followed by a series of And commands, but not the other way around.

Select on Record Number

You can select by record position even though there is no "Record Number" field:

Select              Record Number
<=                  100

Select on date fields

Set the field to be a "Date field" in the Design Screen and configure Date Format in entries.ini. Even if your date format is MMDDYY, you can select using YYYYMMDD format:

Select              Reg Date
GE                  20140301
And
Select              Reg Date
LE                  20140331

Select Event

Select Event works like Select but filters on event data (time, place) instead of database fields:

Select Event        Start
GE                  10:00:00

You can also compare two events:

Select Event        SPLIT1
GE                  FINISH

Selected / Selected Message / Selected Value

The Selected command marks a database field based on the current selection criteria. By default it places an X in the field. Use Selected Message to specify a different value, or Selected Value to copy the contents of another field.

Examples

List males between ages 16 and 20:

Select              AGE
LE                  20
And
Select              AGE
GE                  16
And
Select              SEX
EQ                  M

Mark all finishers with an X in the VERNONXX field:

Selected            VERNONXX
Event               TIME

Change all L values to Z in the CLASS field:

Select              CLASS
=                   L
Selected            CLASS
Selected Message    Z

Copy first names to NickName field where NickName is blank:

Select              NickName
EQ
Selected            NickName
Selected Value      First Name

Mark a field and continue to send email:

Select              sent
EQ
Selected            sent
Continue
Email To            email
Email Server        smtp.myisp.com
Email From          alan@myisp.com
Email Subject       Vernon XX