We are currently working on the forum. For the short-term, all forum content will be in read-only format. We apologize for the interruption and look forward to collaborating with you shortly. All the best in your research!
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.