SQL Queries: /Documentation

SQL Queries

Documentation

SQL Queries

LabKey Server provides rich tools for working with databases and SQL queries. By developing SQL queries you can:

Create filtered grid views of data.
Join data from different tables.
Group data and compute aggregates for each group.
Add a calculated column to a query.
Format how data is displayed using query metadata.
Create staging tables for building reports.

Special features include:

An intuitive table-joining syntax called lookups. Lookups use a convenient syntax of the form "Table.ForeignKey.FieldFromForeignTable" to achieve what would normally require a JOIN in SQL. For details see LabKey SQL Reference.
Parameterized SQL statements. Pass parameters to a SQL query via a JavaScript API.

How are SQL Queries processed?: LabKey Server parses the query, does security checks, and basically "cross-compiles" the query into the native dialect before passing it on to the underlying database.

Topics

LabKey SQL Tutorial - Create a SQL Query.
SQL Query Browser - A dashboard for all things SQL-related, such as database schemas, tables, columns, and queries.
Create a SQL Query - How to create a database query and view the results.
Edit SQL Query Source - How to use the SQL source editor.
LabKey SQL Reference - SQL syntax and reference.
Lookups: SQL Syntax - SQL syntax for lookups.
LabKey SQL Utility Functions - moduleProperty and javaConstant
Query Metadata - Control how your query is displayed using metadata.
Query Web Part - How to show query results in your project.