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.

Topics

Related Topics

Discussion

previousnext
 
expand all collapse all