Delete data once it has been uploaded to survey.calls

[mccuskk]

Currently there is no way for analysts to remove data they have just uploaded so I have created a new function :-

select clear_uploaded_data( survey_id integer, call_plan_date date)

This allows you to clear data you have uploaded accidentally. It will only clear data where there have not been any calls made and will report back why it cannot clear data if you supply the wrong parameters.

So to use you would do something like

select clear_uploaded_data( 229, '2014-10-28')