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 OC 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 '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})); |
clean the data from protocol, you can go to protocol and select existing patients and delete them in one go.Go to the participant list view → select the square icon at the top of the page.
...
Once you select the icon, all the patients on that list view will get selected. Now, click on delete to proceed further.
...
After clicking on the delete button, you will get a notification like below where you will need to provide the reason for deleting the data. Then click on Yes and wait for a bit to clean up the data.
...
Once all metadata is deleted, you can rerun the sync.