Lookup to core.Containers table different from other regular tables? | Jon (LabKey DevOps) | 2016-05-26 16:01 |
Status: Closed | ||
Hi Leo, It looks like your XML between the test version to the actual one are slightly off: Working version for https://test.immunespace.org/query/Studies/executeQuery.view?schemaName=study&query.queryName=GEE_studyCohortsInfo : <?xml version="1.0" encoding="UTF-8"?><tables xmlns="http://labkey.org/data/xml"> <table tableDbType="TABLE" tableName="GEE_studyCohortsInfo"> <columns> <column columnName="Container"> <fk> <fkColumnName>EntityId</fkColumnName> <fkDbSchema>core</fkDbSchema> <fkDisplayColumnName>DisplayName</fkDisplayColumnName> <fkTable>Containers</fkTable> </fk> </column> </columns> </table> </tables> The non-working version for https://test.immunespace.org/query/Studies/executeQuery.view?schemaName=study&query.queryName=Test : <tables xmlns='http://labkey.org/data/xml'> <table tableName='GEE_studyCohortsInfo' tableDbType='NOT_IN_DB'> <columns> <column columnName='Container'> <fk> <fkColumnName>EntityId</fkColumnName> <fkDbSchema>core</fkDbSchema> <fkDisplayColumnName>DisplayName</fkDisplayColumnName> <fkTable>Containers</fkTable> </fk> </column> </columns> </table> </tables> Can you modify your XML to the one that works and see if it makes a difference? Regards, Jon |
||