Query language examples

In the examples below Query Language commands and operators are in bold.

Query Language commands are case insensitive and operators are case sensitive.

Database class or tag names begin with a capital letter, but this is not an Query Language requirement.

`findModel`	lists the database classes (tables) and tags (fields) available for querying
`find` `Locus` `b*`	lists all loci whose names begin with "b" (equivalent to `where >?Locus b*`)
`findPaper` `Author` `=PatErson*`	lists all papers written by Pat Erson
`findLocus` `b` `ANDMap` `=7h`	lists all loci whose names begin with "b" that are located on Maps whose names end in "7h"
`findColleagueMail` `=dakotaAND` `Mail` `=university`	lists all colleagues which have a mailing address containing the string "dakota" and containing the string "university"
`findColleaguejon` `ORsmi`	lists all colleagues whose names begin with "jon" or "smi"
`findAu` `s?s` `ORbs`	lists authors Suseelan, Sasaki, Banks, Bosch, et. al
`findAuthorCOUNT` `Paper` `>100`	lists all authors who are an author on more than 100 papers
`findLocus;follow` `Clone`	lists all mapped clones
`findAuthorjon*;follow` `Paper`	lists all papers written by authors whose names begin with "jon"
`findAuthorcartinhour*;follow` `Paper;follow` `Author`	lists all the coauthors of papers by Cartinhour
`grepadh`	lists all database objects that contain the string "adh" (Note: this often returns too many objects to be useful)

More ACEDB Query Language Examples, by JD Barnett (December 1995)