Search the database schema

Introduction

Queries are the main way of finding data in the database from a collections curator or internal researcher perspective. They are a specific method of searching through the database's tables where you use Boolean logic to filter results. Queries are used in many different parts of the Specify 7 system, and this section is here to help you design, build and save your queries.

Search the Collection Schemas

Each collection has their own configuration of the underlying database structure and tables, called a "schema." This is a quick searchable reference of each collection's database schema.

• Algae
• Birds
• Bryophytes
• Entomology
• Fishes
• Fungi
• Herpetology
• Lichen
• Mammals
• Marine Invertebrates
• Paleontology
• Teaching

Extended Search

This form of advanced searching allows you to fine-tune results.

White space acts as an AND operator, while a single pipe (|) character acts as an OR operator. To escape white space, use double quote ex. ="scheme language" for exact match.

Token	Match type	Description
jscript	fuzzy-match	Items that fuzzy match jscript
=scheme	exact-match	Items that are scheme
'python	include-match	Items that include python
!ruby	inverse-exact-match	Items that do not include ruby
^java	prefix-exact-match	Items that start with java
!^earlang	inverse-prefix-exact-match	Items that do not start with earlang
.js$	suffix-exact-match	Items that end with .js
!.go$	inverse-suffix-exact-match	Items that do not end with .go

Save Queries

Once you have created a query that you're satisifed with and would like to reuse, you can save your query.