UsefulQueries - Ghini/ghini.desktop GitHub Wiki
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.