Custom List metadata on export/import list archive. | Anthony Corbett | 2013-01-21 06:52 |
Status: Closed | ||
I ran in to an issue, it was easy enough to fix, but was wondering if I happen to miss some option during an export of a list archive. I created a list which references study.DataSets.dataSetId as a foreign key. When designing the list this table was not an option to pick from for a lookup. Therefore, in order to wire up the lookup so queries could use the dot notation to the Datasets columns I had to manually add the following table metadata XML through the Schema Browser: <tables xmlns="http://labkey.org/data/xml"> <table tableName="CohortVisit_eCRFSections" tableDbType="TABLE"> <columns> <column columnName="dataSetId"> <datatype>integer</datatype> <columnTitle>Data Set</columnTitle> <fk> <fkDbSchema>study</fkDbSchema> <fkTable>DataSets</fkTable> <fkColumnName>DataSetId</fkColumnName> </fk> </column> </columns> </table> </tables> This worked great and I can now build queries against the list that auto join the DataSet rows using the DataSetId. However, once I exported an archive of the lists from our dev server to production the metaData did not follow it as part of the export. Did I not export this correctly. Just wondering for future reference and to document any 'gotcha' for our dev team. Much appreciated! - Anthony Corbett |
||