Hard table with foreign key to assay run | Will Holtz | 2016-03-08 16:20 |
Status: Closed | ||
Hi -- I am trying to create a hard table that has an FK to an assay run. In the .sql file that creates the table, I have a FK to exp.experimentrun. In the xml file that defines the table metadata I have the following: <?xml version="1.0" encoding="UTF-8"?> <ns:tables xsi:schemaLocation="http://labkey.org/data/xml ..\..\..\..\..\schemas\tableInfo.xsd" xmlns:ns="http://labkey.org/data/xml" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <ns:table tableName="Plate" tableDbType="TABLE"> <ns:columns> <ns:column columnName="OD"> <ns:fk> <ns:fkFolderPath>/home/OD</ns:fkFolderPath> <ns:fkColumnName>RowId</ns:fkColumnName> <ns:fkDbSchema>assay.OD.OD</ns:fkDbSchema> <ns:fkTable>Runs</ns:fkTable> </ns:fk> </ns:column> </ns:columns> </ns:table> </ns:tables> When I view the metadata for this table via the Labkey Schema Browser, it does not show anything under lookup column for this row. Anyone know what I'm missing or if there is a better way of creating the lookup? thanks, -Will |
||