LabKey Support
LabKey Support
Sign In
Documentation
Solutions
Support
Download
Developers
JavaScript is disabled. For the full experience enable JavaScript in your browser.
Start Page
Data and Views
Reports, Views, and Charts
Query Report
Documentation: Version 12.2
Query Report
Print
This topic is under construction for the 12.3 release of LabKey Server.
To create a new query report, go to
Admin -> Manage Views -> Create -> Query Report
.
Attached Files
queryReport.png
Search
Scope
?
Site
Project
Current Folder
Current Folder & Subfolders
Categories
?
Assays
Files and Attachments
Issues
Lists
Messages
Ontology Concepts
Projects and Folders
Study Datasets
Study Subjects
Wiki Pages
Sort
?
Relevance
Created
Modified
Folder Path
Reverse Sort Results
Pages
Print all
Start Here
Install LabKey Server (Quick Install)
Tutorials
Videos and Webinars
Showcase of Live Sites
Platform Overview
Frequently Asked Questions
How to Cite LabKey Server
Learn What's New in 12.2
Release Notes 12.2
12.2 Video Demonstrations
Archive of Release Notes
Learn What's New in 12.1
12.1 Release Notes
12.1 Video Demonstrations
Learn What's New in 11.3
11.3 Release Notes
11.3 Video Demonstrations
Learn What's New in 11.2
11.2 Release Notes
11.2 Video Demonstrations
Learn What's New in 11.1
11.1 Release Notes
11.1 Release Webinar
Learn What's New in 10.3
10.3 Release Notes
Learn What's New in 10.2
10.2 Release Notes
Learn What's New in 10.1
10.1 Release Notes
Learn What's New in 9.3
9.3 Upgrade Tips
Learn What's New in 9.2
9.2 Upgrade Tips
Learn What's New in 9.1
9.1 Upgrade Tips
Learn What's New in 8.3
Learn What's New in 8.2
8.2 Upgrade Tips
Learn What's New in 8.1
8.1 Upgrade Tips
Learn What's New in 2.3
Learn What's New in 2.2
Learn What's New in 2.1
Learn What's New in 2.0
Learn What's New in 12.3
Release Notes 12.3
12.3 Video Demonstrations
Administration
Tutorial: Organization and Security
Step 1: Set Up a Workspace
Step 2: Customize Look and Feel
Step 3: Secure Your Data
Install LabKey
Before You Install
Install LabKey Server via Windows Installer
Install LabKey via Linux Installer
Install LabKey Manually
Install Required Components
Install and Configure Microsoft SQL Server 2008 R2 or 2012
Install PostgreSQL on Windows
Install PostgreSQL on Linux, Unix or Macintosh
Notes on Installing PostgreSQL on All Platforms
Change configuration to run JDK 6 on a Mac
Configure the Web Application
Modify the Configuration File
Third-Party Components and Licenses
Install LabKey Server on Solaris
Install LabKey in the Cloud
Install a Remote Pipeline Server via the Windows Installer
Install the Enterprise Pipeline
Install prerequisites for the Enterprise Pipeline
JMS Queue
Globus GRAM Server
RAW to mzXML Converters
Configure LabKey Server to use the Enterprise Pipeline
Configure the Conversion Service
Configure Remote Pipeline Server
Configure Pipeline Path Mapping
Use the Enterprise Pipeline
Create a New Globus GRAM user
Troubleshoot the Enterprise Pipeline
Example Setups and Configurations
Set up a JMS-Controlled Remote Pipeline Server
Install CPAS on Linux
Example Installation of Flow Cytometry on Mac OSX
Configure R on Linux
Configure the Virtual Frame Buffer on Linux
Common Install Tasks
Install and Set Up R
Install SAS/SHARE for Integration with LabKey Server
Configure Webapp Memory
Set Up Robots.txt and Sitemaps
Upgrade LabKey
Upgrade LabKey via the Linux Installer
Manual Upgrade
Manual Upgrade Script for MacOSX, Solaris and Unsupported Linux Distributions
Upgrade Support Policy
Supported Technologies
Old Tomcat Versions
Projects and Folders
Plan Site Structure
Navigate Site
Folder Management
Create a Folder / Subfolder
Move/Delete/Rename Folders
Export / Import a Folder
Hidden Folders
Add Web Parts
Manage Web Parts
Workbooks
Establish Terms of Use for Project
Security
Authentication
Basic Authentication
Single Sign-On Overview
Configure LDAP
Set Up OpenSSO
Draft Material for OpenSSO
Create a .netrc or _netrc file
Site Administrator
User Accounts
Add Users
Manage Users
My Account
Manage Project Users
Guests
Security Groups
Global Groups
Project Groups
Site Groups
Site Group: Developer
Configure Permissions
Security Roles Reference
Test Security Settings by Impersonation
Passwords
Configure Password Rules
Admin Console
Site Settings
Look & Feel Settings
Web Site Theme
Email Customization
Audit Site Activity
Manage Missing Value Indicators / Out of Range Values
Configure Scripting Engines
Backup and Maintenance
Backup Checklist
A Sample Backup Plan
Sample Scripts for Backup Scenarios
Maintenance
Administer the Site Down Servlet
Staging, Test and Production Servers
Example of a Large-Scale Installation
Tips for Configuring a Staging Server
Troubleshooting
Installation Troubleshooting
Dump debugging information
Files
File Management Tutorial
Step 1: Set Up a Workspace
Step 2: Upload Files
Step 3: Search the Data
Step 4: Share the Data
Upload Files
Import Files
Share and View Files
Advanced File Sharing
Set Up File Sharing
Use File Sharing
File Administrator Guide
File Terminology
Files Web Part Administration
Set Web and File Roots
Data Processing Pipeline
Set a Pipeline Override
Troubleshoot File Roots and Pipeline Overrides
WebDav
BioTrue
Data and Views
Data Analysis Tutorial
Step 1: Set Up a Workspace
Step 2: Import Data to a List
Step 3: Sort and Filter Data
Step 4: Visualize Data Trends
Step 5: Create an R View
Step 6: Join Multiple Tables
Data Grids
Data Grids: Basics
Sort Data
Filter Data
Select Data
Customize Views
Pre-Define Filters and Sorts
Join Views with Lookup Columns
Export Data
Export Scripts
Customize Participant Views
Filter by Folder
Reports, Views, and Charts
Attachment Reports
Box Plots
JavaScript Views
Link Reports
Participant Reports
Query Report
Quick Charts
R Views
Access the R View Builder
Author Your First R View
Upload a Sample Dataset
Access Your Dataset
Load Packages
Determine Available Graphing Functions
Graphics File Formats
Use Input/Output Syntax
Work with Saved R Views
Create Advanced Scripts
Means, Regressions and Multi-Panel Plots
Basic Lattice Plots
Participant Charts
User-Defined Functions
R Tutorial Video for v8.1
FAQs for LabKey R Views
Scatter Plots
Time Charts
Legacy Reports
Advanced Views / External Reports
Chart Views
Crosstab Views
Enrollment Views
Workbook Reports
Display a Report or View
Manage Reports and Views
Custom SQL Queries
The Query Schema Browser
Display a Query's Source
Create or Edit a Custom Query
Use the Source Editor
Edit Query Metadata
Edit Query Properties
Display a Query
Add a Calculated Column to a Query
Use Cross-Folder & Cross-Project Queries
Fields with Dependencies
LabKey SQL Reference
SQL Examples: JOIN, Calulated Columns, GROUP BY
Write a Pivot Query
LabKey Data Structures
Options for User-Defined Tables
Lists
Simple List Tutorial
Advanced List Tutorial
Advanced List Tutorial: Set Up
Create Lists and Set Up Lookups
Create a Joined View to Investigate Results
Add a URL Property
Create and Populate Lists
Option 1: Create a list by importing a single data file
Option 2: Create a list by defining and populating fields
Option 3: Create lists by importing a list archive
Add More Data to a List
Manage Lists
Edit a List Design
Field Properties
Conditional Formats
Date and Number Formats
Choose a Primary Key
Change Insert/Edit/Details Field Order
External Schemas and Data Sources
External MySQL Data Sources
External Oracle Data Sources
External Microsoft SQL Server Data Sources
External PostgreSQL Data Sources
External SAS Data Sources
Search
Search Administration
Collaboration
Collaboration Tutorial
Step 1: Set up a Workspace
Step 2: Set up a Message Board
Step 3: Collaborate Using a Wiki
Step 4: Set up an Issue Tracker
Create a Collaboration Folder
Issues
Using the Issue Tracker
Administering the Issue Tracker
Messages
Use Message Boards
Administer Message Boards
Notifications for Message Boards
Contacts
Wiki
Wiki Admin Guide
Copy Wiki Pages
Wiki User Guide
Wiki Syntax Help
Advanced Wiki Syntax
Embed Live Content in Wikis
Web Part Configuration Properties
Examples: Embedded Web Parts
Search Documentation
Add Screenshots to a Wiki
Manage Wiki Attachment List
Discuss This
Camtasia Tips and Tricks
Studies
Study Tour
Study Tutorials
Tutorial: Study Features
Step 1: Install the Demo Study
Step 2: Explore the Demo Study
Step 3: Sort and Filter Grid Views
Step 4: Create a Chart
Step 5: Create an R View
Create an R View with Cairo
Step 6: Explore Specimens
Tutorial: Set Up a New Study
Set Study Properties
Set Up Time Points
Import Datasets
Assign Cohorts
Set Up Specimens
Enable Comments
Study Adminstrator Guide
Create a Study
Directly Create Study
Create an Ancillary Study
Import, Export, and Reload a Study
Study Import/Export Files and Formats
Serialized Elements and Attributes of Lists and Datasets
Use Study Designer
Manage a Study
Manage Datasets
Manage Visits or Timepoints
Study Schedule
Manage Labs and Sites
Manage Cohorts
Manage Comments
Manage Study Security
Configure Permissions for Reports & Views
Matrix of Dataset-Level and Folder-Level Permissions
Manage Dataset QC States
Demonstration Mode
Publish a Study
Define and Map Visits
Advice on Defining Visits
Manually Create and Map Visits
Create a Visit
Edit Visits
Map Visits
Identify Visit Dates
Import Visits and Visit Map
Import Visit Names / Aliases
Create and Populate Datasets
Direct Import Pathway
Create a Dataset from a File
Create a Dataset by Defining Fields
Create Multiple Datasets from schema.TSV
Dataset Properties
Dataset Fields
Field Properties
Pre-Defined Fields
Study Date & Number Formats
Import Data Records
Import Through the Files Web Part
Import via Copy/Paste
Import From a Dataset Archive
Create Pipeline Configuration File
Manage Your New Dataset
Manage Specimens
Import a Specimen Archive
Specimen Archive File Reference
Specimen Archive Data Destinations
Troubleshoot Specimen Import
Import Specimens Via Cut/Paste
Set Up Specimen Request Tracking
Approve Specimen Requests
Configure Specimen Requestability Rules
Annotated Study Schema
Study User Guide
Data Browser
Site Navigation
Study Navigation
The Study Navigator
Select, Sort, Filter & Export Data
Reports and Views
Cohorts
Participant Groups
Comments
Dataset Import
Dataset Quality Control
Assays
Specimens
Specimen Shopping Cart
Specimen Reports
Specimen Quality Control
Wiki User Guide
Accounts and Permissions
Password Reset & Security
Permissions
Your Display Name
Assays
Assay Tutorials
Tutorial: Introduction to Assay Tools
Assay Tutorial Set Up
Infer an Assay Design from Spreadsheet Data
Import Assay Data
Edit the Assay Design
Configure Data Validation
Set up a Data Transformation Script
Add Assay Data to a Study
ELISpot Assay Tutorial
NAb (Neutralizing Antibody) Assay Tutorial
Review plate data file formats
Create a custom NAb plate template
Luminex® Assay Tutorial Level I
Review Luminex® file formats
Perform basic setup
Create a new Luminex® assay design
Import Luminex® run data
Exclude analytes for QC
Import multi-file runs
Copy luminex data to study
Luminex® Assay Tutorial Level II
Perform basic setup
Import lists and assay design
Configure R, packages and script
Import Luminex® runs
View 4pl and 5pl curve fits
Track analyte quality over time
Use guide sets to show expected ranges
Review optional shortcuts
Troubleshoot Luminex transform scripts and curve fitting results
Microarray Assay Tutorial
Viability Assay Tutorial
Assay Administrator Guide
Set Up Folder For Assays
Import Assay Design
Design a New Assay
Field Properties
General Properties
ELISpot Properties
Luminex Properties
Create a custom assay for script
Review fields for script
Microarray Properties
NAb Properties
Edit Plate Templates
Illumina Properties
Manage an Assay Design
Copy Assay Data To Study
Copy-To-Study History
Experiment Descriptions & Archives (XARs)
Experiment Terminology
Samples and Sample Sets
Run Groups
XAR.xml Tutorial
Uses of XAR.xml Files
Import a XAR.xml
Troubleshoot XAR Import
Import XAR Files Using the Data Pipeline
Example 1: Review a Basic XAR.xml
Examples 2 & 3: Describe Protocols
Examples 4, 5 & 6: Describe LCMS2 Experiments
Design Goals and Directions
Life Science Intentifiers (LSIDs)
LSID Substitution Templates
Assay User Guide
Import Assay Runs
Import General Assays
Import ELISpot Runs
Import Luminex Runs
Luminex Conversions
Import Microarray Runs
Import NAb Runs
Work With Assay Data
Proteomics
Proteomics Tutorial
Set Up for Proteomics Analysis
Search mzXML Files
View PeptideProphet Results
View ProteinProphet Results
Compare Runs
Search for a Specific Protein
Proteomics Video
Get Started With LabKey Proteomics
Explore the MS2 Dashboard
Upload MS2 Data Via the Pipeline
Set Up MS2 Search Engines
Working with mzML files
Set Up Mascot
Set Up Sequest
Install SequestQueue
Set the LabKey Pipeline Root
Search and Process MS2 Data
Set Up MS Search Engines
Configure Common Parameters
Configure X! Tandem Parameters
Configure Mascot Parameters
Configure Sequest Parameters
Sequest Parameters
MzXML2Search Parameters
Examples of Commonly Modified Parameters
Import Existing Analysis Results
Launch MS2 pipeline jobs when files are available
Change the versions of the proteomics search tools used by the pipeline
Work with MS2 Runs
View an MS2 Run
Customize Display Columns
Peptide Columns
Protein Columns
View Peptide Spectra
View Protein Details
View Gene Ontology Information
Compare MS2 Runs
Compare ProteinProphet
Export MS2 Runs
View, Filter and Export All MS2 Runs
Protein Search
Peptide Search
Loading Public Protein Annotation Files
Using Custom Protein Annotations
Using ProteinProphet
Using Quantitation Tools
Experimental Annotations for MS2 Runs
Exploratory Features
Spectra Counts
Label-Free Quantitation
MS1
MS1 Pipelines
Proteomics Team
Flow Cytometry
Overview
Flow Team Members
Flow Module
Tutorial: Import a Flow Workspace
Set up a Flow Workspace
Upload Files to Server
Import a Flow Workspace and Analysis
Customize Your View
Examine Graphs
Examine Well Details
Finalize a Dataset View and Export
Tutorial: Perform a LabKey Analysis
Define a Compensation Calculation
Define an Analysis
Apply a Script
View Results
Add Sample Descriptions
Custom Flow Queries
Add Statistics to FCS Queries
Calculate Suites of Statistics for Every Well
Flow Module Schema
FCS Express
Tutorial: Import Flow Data from FCSExpress
Reagent Inventory
FCS keyword utility
DNA Sequencing & Genotyping
Genotyping Tutorial
Development
Introductory Materials
Set up a Development Machine
Notes on Setting up a Mac for LabKey Development
Machine Security
Enlisting in the Version Control Project
Source Code
Tutorial Video: Building Views and Custom User Interfaces
Recommended Skill Sets
Recommended Tools
Web Application Security
Develop Modules
Tutorial: "Hello, World!" Module
Map of Module Files
Create a New Module
Enable a Module in a Folder
Add Resources to a Module
Token Replacement in Static HTML Files
Queries, Views and Reports in Modules
Add a Custom Query View
Add a Custom SQL Query and R Report
Add File-Based R Reports to the Views Menu
Add an HTML View and Web Part
Include a Module Properties File
Include Database Transition Scripts
Custom Button Bars
Example: Column Metadata for a Query
Custom Folder Types
Credits
Writing SQL Scripts
Develop & Deploy a Module
Upgrade Modules
Java Modules
Module Architecture
Getting Started with the Demo Module
Creating a New Java Module
The LabKey Server Container
Creating Views
Implementing API Actions
Maintaining the Module's Database Schema
Integrating with the Pipeline Module
Integrating with the Experiment Module
GWT Integration
GWT Remote Services
Java Testing Tips
HotSwapping Java classes
Deprecated Components
Develop Assays
Tutorial: Build an Assay Module
Assay Custom Domains
Assay Custom Views
Example Assay JavaScript Objects
Assay Query Metadata
Transformation Scripts
Transform Scripts in R
Transform Scripts in Java
Transform Scripts for Module-based Assays
Schemas, Queries, and Metadata
LabKey Keys
LabKey Table Schemas
Trigger Scripts
How To Find schemaName, queryName & viewName
LabKey URLs
Web Part Configuration Properties
LabKey XML Schemas
Table Metadata XML
The LabKey Ontology & Query Services
LabKey Client APIs
JavaScript API
Tutorial: JavaScript API
Reagent Request Form
Reagent Request Confirmation Page
Summary Report for Reagent Managers
Tutorial: Build URLs & Filters + Pass Info Between Pages
Choose Parameters
Show Filtered Grid
Tutorial: JavaScript Chart APIs
Tips for Using Ext to Build LabKey Views
Declare Script Dependencies
Using Ext4
Migration to Ext4
Migrating Custom Applications From Ext3 to Ext4
Licensing for the Ext API
Naming & Documenting JavaScript APIs
Naming Conventions for Javascript APIs
How to Generate JSDoc
JsDoc Annotation Guidelines
Java API
Prototype LabKey JDBC Driver
Perl API
Python API
Advanced Tutorial: Python API
Set up the Python API
Use the Python API
Rlabkey Package
SAS Macros
SAS Setup
SAS Macros
SAS Security
SAS Demos
HTTP Interface
Examples: Controller Actions
Example: Access APIs from Perl
LabKey Open Source Project
Development Cycle
Project Process
Release Schedule
Issue Tracker
LabKey Scrum FAQ
Developer Email List
Feature Owners
Previous Releases
Previous Releases -- Details
Submit Contributions
Confidential Data
CSS Design Guidelines
UI Design Patterns
Design Guidelines Supplemental
Documentation Style Guide
Check Into the Source Project
previous
next
expand all
collapse all
queryReport.png
