Tips For Searching the Women's Rosters
To search the database, simply type the term(s) or phrase into the text box, select the search option (equals, begins with, contains or not equal) and press the "Find" button.
Search on multiple fields -- enter search terms in the text boxes for two or more fields, select the search option and press the "Find" button. (all multiple field searches are "AND" searches. It is not currently possible to do "OR" searches.)
Number, Year and Date Range searches are numeric searches, only number values will return proper results.
Searches look for exact matches. If you do not get expected results, or are not sure of spelling, try using the "begins with" or "contains" search options.
Search options:
- equals -- finds exact content of the field
- searching for "lastname=Johns" will find Johns, but not Johnson or Johnston
- begins with -- finds any word in the field that begins with the character string
- searching for "firstname begins with Ann" will find Ann, Ann, and AnN, but not MaryAnn
- contains -- finds the character string anywhere in the field
- searching for "lastname contains John" will find Johns, Johnson, Johnston and Prettyjohn
- not equal -- finds all records that do not include the specified text string
- searching "lastname contains "fins" and "first name not equal Samantha" will find Angela Findlay, Becca Garfinkel and Sarah Griffin, but not not Samantha Findlay.
Searching by Date
- Year -- searches for a single year (a "not equals" search would eliminate a single year"
- Date Range -- uses a begin-date and end-date to search a range of years. (to find all players from the 1980s, search for "begin date=1980" and "end date=1989"). The Date Range search must include a valid end date.
Sorting results
Results can be sorted in a variety of ways. Before pressing the "Find" button, select the order in which you want the results to be sorted. The default sort is by lastname-firstname-year.
The options are:
| Option | Full Sort Order |
|---|---|
| name-year | lastname-firstname-year |
| year-name | year-lastname-firstname |
| year-number | year-number-lastname-firstname |
| number-year | number-year-lastname-firstname |
| number-name | number-lastname-firstname-year |
| letter-year | letter winners, year, lastname-firstname, the non-letterwinner |
| year-letter | year-letterwinners-lastname-firstname, non-letterwinners |
| letter-name | Letterwinners, lastname-firstname-year, non-letterwinners |