This tutorial introduces you to Lists
, the simplest way to represent tabular data in LabKey. While straightforward, lists support many advanced tools for data analysis. Here you will learn about the power of lookups
, and URL properties
for generating insights into your results.
Lists can be simple literal one column "lists" or many columned tables with a set of values for each "item" on the list. A list must always have a unique primary key - if your data doesn't have one naturally, you can use an auto-incrementing integer to guarantee uniqueness.
Lists offer many data connection and analysis opportunities we'll begin to explore in this tutorial:
- Lookups can help you display names instead of code numbers, present options to users adding data, and interconnect tables.
- Joins help you view and present data from related lists together in shared grids without duplicating information.
- URL properties can be used to filter a grid view of a list OR help you link directly to information stored elsewhere.
Completing this tutorial as written requires administrative permissions, which you will have if you create your own server trial instance in the first step. The features covered are not limited to admin users.