When you want to resync the data in the protocol, you can clear the tables DB where the data is stored using the ‘Delete Data' feature. Once you clean the table via UI, you can delete the patients, visits, and specimens.
Go to the OpenClinica Configuration page of the study for which you wish to delete the study mapping. Click on 'More' → Delete Data.
...
Once you click on the ‘Yes' on the above popup, study data will be deleted, and you will get a notification '<add notification>’.
Study data before deleting
<Add SS>
Study data after deleting
<Add SS>Study data deleted’.
...
To verify if the tables are cleaned in the database. You can create a query and ensure that it returns null results.
Patient Table
| Code Block |
|---|
select * from os_oc_subjects
where study_id in (select identifier from os_oc_studies where cp_id = {CP_ID});
|
...
Visit Table
| Code Block |
|---|
select * from os_oc_visits
where subject_id in (select identifier from os_oc_subjects
where study_id in (select identifier from os_oc_studies where cp_id = {CP_ID})); |
