A few LabKey fields (a.k.a. columns) have dependencies. To use a field with dependencies in a custom SQL query, you must explicitly include supporting fields.

Assay ID

To use Assay ID in a query, you must include the run's RowId and Protocol columns. You must also use these exact names for the dependent fields. RowId and Protocol provide the Assay ID column with data for building its URL.

If you do not include the RowId and Protocol columns, you will see an error for the Run Assay ID field. The error looks something like this:

"KF-07-15: Error: no protocol or run found in result set."


previousnext
 
expand allcollapse all