• Sign In
×
The 2025 Client Survey is now open! Responses will be accepted up until 10/31. Please feel free to share this link within your organization and we thank you in advance for your participation!
  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!