File based Assay and hard tables for domains

LabKey Support Forum (Inactive)
File based Assay and hard tables for domains kevink  2013-02-07 13:02
Status: Closed
 
Hi Anthony,

The file-based assay, the general assay, and Elisa types all create a hard tables for the result domain and store result data there. The batch and run domains aren't created as hard tables yet and store their data in the property store. The java Elispot assay doesn't create a hard table for it's result data yet and uses the property store instead.

It is possible to add sql scripts to a file based module and create hard tables, however these tables won't be used by the assay framework to store assay data. You could create these hard tables if you need to store lookup data that you manage outside of the assay framework.

Adding hard tables to a file based module is pretty easy and there are lots of examples in our svn tree on how to do it. You'll need to add sql scripts for postgres and sqlserver and then create a xml file describing the tables. Please see the se docs for more:

https://www.labkey.org/wiki/home/Documentation/page.view?name=sqlScripts
https://www.labkey.org/wiki/home/Documentation/page.view?name=schemaUpdates
https://www.labkey.org/wiki/home/Documentation/page.view?name=includeDatabaseScripts