Restore Deleted Surveys

[kfisher]

Question : How do I restore all deleted surveys in my application?

Solution : Run the following script on your Checkbox Database

UPDATE 
ckbx_Template 
SET 
Deleted = 0

Question: How do I restore a specific survey in my application ?

Whats needed? : You will need either the ID of the survey or the survey's GUID in order to restore a specific survey.

If you have the ID of the survey, you can run the following script, please replace [ID] with the ID of the survey.

Solution :

UPDATE
ckbx_Template
SET 
Deleted = 0
WHERE
TemplateID = [ID]

If you have the GUID for the survey, you can run the following script, please replace [GUID] with the GUID of the survey.

Solution :

UPDATE ckbx_Template
SET deleted = 0
  WHERE TemplateID
        = 
        ( SELECT crt.ResponseTemplateID
            FROM dbo.ckbx_ResponseTemplate crt
            WHERE crt.GUID = '[GUID]'
        )