UsefulQueries

this is a list of possibly useful queries

please contribute following the same structure as the first few examples provided.

some of them, you will definitely want to put in your stored queries.

list all species in families starting with an A

species where genus.family.family like 'A%'

list all families

fam like %

this might take some time

list species in unidentified genera

species where genus.genus like 'Zzz%'

a listing of species unidentified genus but to get all you have to add something with sp too...

not yet identified accessions

accession where species.species = 'sp' or species.genus.genus like 'Zzz'

what has happened recently to the database

:history

this is not too well documented, and hugely useful. with this one you can quickly review recent changes to the database, and just as quickly jump to the listed edited objects. lines associated to database objects for which there is an editor will react to double clicking by switching the view to the results view, focused on the object on which you double clicked.