• Sign In
×
Maintenance Notice: labkey.org will be offline for maintenance tonight @ 6pm Pacific Time. The estimated downtime will be approximately one hour. Sorry for any inconvenience this may cause.
  1. Messages

Deleting record in Assay from Stored Procedure

LabKey Support Forum (Inactive)

View Message

view list print
Deleting record in Assay from Stored Procedure marcia hon  2018-06-04 09:50
Status: Closed
 

Hello,

I have an ETL Stored Procedure that gets data from an Assay.

Now, I would like that once this data has been copied to another table, that the data is erased in the Assay.

How do I do this in the Stored Procedure?

Thanks,
Marcia
 
 
marcia hon responded:  2018-06-05 07:44

I found a solution.

To reference any tables in Stored Procedure / ETL , you need to reference how it is named in Postgres.

For example, if I have an assay called "test", in Postgres, it is stored in "assayresult" with the table name of "c123456_test".

So to reference it in Postgres, you would use: assayresult.c123456_test .

Thanks!