Writing BFV Queries
Queries are simple text strings specifying values for one or more data fields. For example, the phrase taxon = 'Equidae' asks for all references containing information about the family Equidae — that is, where there is a match between the taxon field and the value 'Equidae'. You must enclose the value in single quotes, but spacing doesn't much matter. You may string together several criteria using and and or, and you may use partial matching (described below). For example, the query taxon='Australopithecus' and taxon='boisei' and au != 'Wood' and date < '1988' retrieves all references for Australopithecus boisei where Wood was not an author and that were published before 1988.
Available search fields:
- au — author (last name)
- fn — author (first name(s))
- su — subject
- ti — title
- jn — journal (abbreviated form)
- trans — (title translated into English, where available)
- lang — (text language, where specified other than English)
- edvol — (title of edited volume [monograph] in which articles are found)
- ed — editor of an edited volume
- pub — publisher
= (equals), != (not equal to), > (greater than), < (less than), like (partial match). The like operator is best used in conjuction with the % symbol, which stands for one or more arbitrary characters. This is particularly useful in looking for terms embedded in titles, e.g., ti like''%plate tectonic%'. This would retrieve all articles with "plate tectonic" or "plate tectonics" anywhere in the title. To find all titles beginning with "Plate tectonics", you would use ti like 'Plate tectonic%'.
The server is case-sensitive with regard to taxa. Taxa other than species begin with upper-case letters, the rest of the words always in lower-case (i.e., use Tyrannosaurus, not tyrannosaurus or TYRANNOSAURUS). Subjects begin with an upper-case letter, but are lowercase thereafter (except for proper nouns). The available subjects are the headings in the published BFV's cross-reference indices, and include geographic regions, countries, time periods, and miscellaneous other descriptive information.
Treatment of subjects is not consistent throughout all of the original BFV volumes, and the Romer volume was never indexed in any way. Thus the following points need to be kept in mind:
- North America, pre-1928 (Hay vols.): Subject information was not tied to references in these volumes, but rather to fossil species (and sometimes genera or other higher taxa). It has proven impossible to recover meaningful subject headings for references from the Hay indexes, so no subject entries are available.
- Outside North America, pre-1928 (Romer vol.): There was originally no taxonomic index, but in the BFV Online genera and species mentioned in the titles of the roughly 40,000 references have been added to the general taxonomic index. Thus, searching on taxon will retrieve at least some of the relevant older literature outside of North America. There are also no subject entries for any of these references. In order to search these references for higher taxa or other content, the best that can be done is a series of title searches (using the like operator, see above).