Lookup to core.Containers table different from other regular tables?

LabKey Support Forum (Inactive)
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