Please join your peers on either March 26 (8pm GMT) or March 28 (8am GMT) to watch as user extraordinaire and forum legend @"lindsay.stevens" demonstrates OpenClinica Insight.

See preview and register at

Insight makes it easy to ask questions of ALL of your clinical and operational data and visualize answers via interactive reports and dashboards. The idea is simple, but the results are powerful: ask your questions, choose your visualizations, then return often for updated, interactive results that link you to all of the underlying data.

Data unlocking

I have to upload a new version of a CRF and reassign the previous versions to this version. Is there a way of unlocking all the locked events in one go (behind the scenes) instead of having to unlock each individual event in order to reassign the new CRF version?


  • haenselhaensel Posts: 570 ✭✭
    I highly recommend to try this with testdata only and never do it in a production environment since it is neither tested nor documented and your auditor might not accept such an intrusion.

    The table study_event has a column "subject_event_status_id" that holds the status of an event. The table event_crf has to be updated too (date_updated) to mimic the original behavior of oc.


Sign In or Register to comment.