Library: SQL for the Public Website
The GG website has a feature in which genebank staff can submit read-only queries. Your PW account must be associated to your Curator Tool account by the GG administrator. (Contact your GG administrator for more information.)
Refer to the SQL Quick Guide (.pdf)(.docx) for an overview. This document contains SQL examples using GRIN-Global tables and fields. Also included are SQL statements which can be used to determine the GG table and field names.
In 2023, two Q&A sessions focused on writing SQL queries. Check out these two links to review the two sessions' video recordings and their associated PowerPont presentations:
The document SQL the Public Website Queries (.pdf) (.docx) contains SQL examples which can be copied into the PW query box. The statements will need to be adjusted to meet the specifics of an organization's GG installation.
Refer to the SQL Quick Guide (.pdf)(.docx) for an overview. This document contains SQL examples using GRIN-Global tables and fields. Also included are SQL statements which can be used to determine the GG table and field names.
In 2023, two Q&A sessions focused on writing SQL queries. Check out these two links to review the two sessions' video recordings and their associated PowerPont presentations:
The document SQL the Public Website Queries (.pdf) (.docx) contains SQL examples which can be copied into the PW query box. The statements will need to be adjusted to meet the specifics of an organization's GG installation.
The file JOIN Examples is referenced by the SQL Quick Guide and illustrates the key fields by which some of the frequently used GG tables relate to each other.
The file GRIN-Global Table Names contains multiple spreadsheets, including a list of table names along with the SQL to produce this list. The other worksheets are grouped loosely by areas. The last three worksheets are the site inventory tables, site short names with IDs, and the code groups and codes. In some cases the SQL is included where applicable.