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 |
||