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."