Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Introduction

When the form is attached at all CPs and the data entry is already done in multiple CPs. Follow the below steps to move the form from all CPs to a specific set of CPs i.e CPG without loss of This page explains how to delink forms attachment from ‘All current and future collection protocols’ and link to specific protocols or collection protocol group(CPG). If data is already entered and if form attachment is changed via UI, data is lost. Follow below steps to do it without losing data.

Steps

Scenario: The ‘Visit Form' form is attached at the ‘Visit Forms’ level to 'all CPs’ and needs to be moved to under ‘Common workflow’ CPG.

...

1. The ‘Visit Form' attached at the 'Visit Forms’ level to all CPs.

...

Log in to the database and run the below SQL query to get the context id of the form which is attached at to all CPs.

Expand
titleSQL for old context ID

Code Block
Select fc.identifier from catissue_form_context FC 
join dyextn_containers dc on dc.identifier=fc.CONTAINER_ID 
where dc.name ='<Form Name>';

You can get the form name form from the UI. Form list view → click on the form name → Copy form name.

...

The user will get the form context id(identifier) form context id of the form as shown in the below image.

...

Form list view → click on the setting icon → click on dustbin delete icon → Done.

...

3. Attach the form at the CPG.

...

4. Run the below SQL for CP ids in the CPG and to get the new context ID of the form which is attached at the CPG.

...