Categories
- 5.7K All Categories
- 157 Discussions
- 71 General Discussion
- 17 Roadmap & New Feature Ideas
- 28 Add-Ons & Code Contributions
- 41 Forum How-Tos
- 803 Q & A
- 170 Installation & Setup
- 308 Study Build, Rules, and CRFs
- 119 Data Entry, Monitoring, and Data Management
- 89 Extracting & Reporting
- 8 Regulatory Compliance
- 25 Rule Designer
- 73 Web Services & Integration
- 11 Internationalization and Localization (i18n / L10n)
- 8 Announcements & Updates
- 8 Announcements & Updates
- 4.8K Archives
- 3K Users Mailing List
- 1.8K Developer Mailing List
Completely Remove Event
OCStu
Posts: 12 ✭
Hi All,
I am testing and interface to OC and now have 200 odd events against a single subject/CRF. I'd like to wipe them completely so that they don't even show up in the list anymore.
I could restore the DB to its original state but I don't want to go that far!!
I understand that there is an audit function and I don't want to break the relationship by deleting events from the database without safely navigating that.
Has anyone done this before? Its not for production, just while testing so I can reset events to a manageable no etc.
Cheers in advance.
I am testing and interface to OC and now have 200 odd events against a single subject/CRF. I'd like to wipe them completely so that they don't even show up in the list anymore.
I could restore the DB to its original state but I don't want to go that far!!
I understand that there is an audit function and I don't want to break the relationship by deleting events from the database without safely navigating that.
Has anyone done this before? Its not for production, just while testing so I can reset events to a manageable no etc.
Cheers in advance.
0
Comments
I normally do not mess with the database since it is pretty complex to understand and often the informations are spread over a lot of tables.
While testing I set up a study as needed and afterwards I make a database dump that I restore the database from before restarting the tests.
It takes me just a couple of seconds to reset the test environment .
Regards,
Christian