We hope you'll join us for our 4/23 webinar on using data tables to apply reference ranges and AE codes in OC4. For more information and to register, visit https://register.gotowebinar.com/register/2882170018956684555

Delete excess rows for a participant

My users have uploaded some excess rows for a couple of study subjects and they want me to delete them. I have been looking through the forums to see if there is a safe way to do this, but I have not found any information. Has anyone attempted this? Is there a particular column in the discrepancy table or item table that I need to key on? So far the schema does not seem to want to delete anything. So I started to look at the deleted column on the item table and wondered if OC just marks rows as deleted so they do not display in the GUI. Looking at the delete_rules for these tables none of them seem to have cascade. I see 'RESTRICT', 'NO ACTION' or 'SET NULL'. Point me in a direction that I can investigate.

Sign In or Register to comment.