Description:
Rows in the assertions table associated with ClinicalTrials.gov and EU Clinical Trial Register are not data citations and need to be removed. This task aims to clean the database by removing these inaccurate entries.
Tasks:
Identify rows with repository_idfef75a3c-6e48-4170-be9d-415601efb689 (ClinicalTrials.gov) or 2638e611-ff6f-49db-9b3e-702ecd16176b (EUCTR).
Execute the query to remove these rows.
Query:
DELETE FROM assertions
WHERE repository_id IN (
'fef75a3c-6e48-4170-be9d-415601efb689',
'2638e611-ff6f-49db-9b3e-702ecd16176b'
);
Validation:
Before executing the deletion, count the number of rows matching the criteria.
After execution, verify that these rows have been removed.
Description: Rows in the assertions table associated with ClinicalTrials.gov and EU Clinical Trial Register are not data citations and need to be removed. This task aims to clean the database by removing these inaccurate entries.
Tasks:
repository_id
fef75a3c-6e48-4170-be9d-415601efb689
(ClinicalTrials.gov) or2638e611-ff6f-49db-9b3e-702ecd16176b
(EUCTR).Query:
Validation:
Before executing the deletion, count the number of rows matching the criteria. After execution, verify that these rows have been removed.