Custom Schema and Table

LabKey Support Forum
Custom Schema and Table marcia hon  2018-04-19 09:20
Status: Closed
 

Hello,

I created a custom schema and table in Labkey via ETL script.

Now, when I am at Labkey GUI and open this table, the option to "delete" is unavailable.

Please is there a way to allow for "delete".

Thanks,
Marcia

 
 
Jon (LabKey DevOps) responded:  2018-04-27 15:52
Hi Marcia,

ETLs themselves do not make custom schemas and tables. That is the responsibility of SQL scripts:

https://www.labkey.org/Documentation/wiki-page.view?name=sqlScripts

However, the ability to delete should exist along with the ability to insert new rows as well provided you didn't configure the XML that renders your table to

Can you send a screenshot of the table in question?

Also, how does your SQL and XML code for your custom schema and table look when compared to our sampletest module here?

https://hedgehog.fhcrc.org/tor/stedi/trunk/server/test/modules/simpletest/resources/schemas/

Regards,

Jon
 
marcia hon responded:  2018-05-16 05:03
Hello,

The attached is the table that I created via an ETL script.

You can see that I am unable to "delete".

Please let me know how to correct this.


Also, I am unable to access: https://hedgehog.fhcrc.org/tor/stedi/trunk/server/test/modules/simpletest/resources/schemas/

Thanks,
Marcia
 
Jon (LabKey DevOps) responded:  2018-05-18 14:39
Hi Marcia,

You will need to use the username and password "cpas" to access the site.

Please use the username/password and take a look at the module and compare it to your existing one.

Regards,

Jon