Custom SQL Queries Tek Wojenski  2017-06-07 07:40
Status: Closed
 
Hi Josh

My goal is to use a new/custom table I created in the postgres database. This table name is: aaa, and it has one column: c1.

I added this script to my module; mymodule\schema folder, in file: study.xml

<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 tableDbType="TABLE" tableName="aaa">
        <ns:titleColumn>Name</ns:aaa>
        <ns:description>test column</ns:description>
        <ns:columns>
            <ns:column columnName="c1"/>
        </ns:columns>
    </ns:table>
</ns:tables>

My thinking was that this would allow me to access/use the aaa in the Labkey Query and in the Schema Browser, but when I try, I get: table not found error. What am I missing?

Regards

Tek Wojenski