hard table with lookup to second hard table in different folder | Will Holtz | 2015-09-09 15:21 |
Status: Closed | ||
Hi Jon, Initially I had metadata for the lookup column with just: <column columnName="product"></column> and later I tried: <column columnName="product"> <fk> <fkFolderPath>/home/folder1</fkFolderPath> <fkTable>Table1</fkTable> <fkDbSchema>Schema1</fkDbSchema> </fk> </column> Neither of these resulted in a functional lookup within labkey. If I edit the metadata from within the labkey schema browser, it appears to already have the lookup configured, as the 'Type' column shows the fk schema and table. However, if I try to edit the lookup, the 'Choose Field' dialog has the value for schema, but doesn't have values for Folder or Table (they say 'Folder' and 'no tables found'). If I then set Folder to /home/Module1, I can then select the table. If I save this and go back to the schema browser, the lookup column is still empty for this field, and when I view the data, I see the integer values for this column. thanks for you help! -Will |
||