@mania
Were you ever able to figure this out? I just ran into the same thing and discovered there is a canDeleteMetric function being called from the AssessmentUtils Script Includes that controls when a Metric from asmt_metric can be deleted.
For my use case, I had to delete all records from the Metric Results (asmt_metric_result) table that were tied to the Metric that needed to be deleted. Once that was complete, I was able to delete the Metric.
canDeleteMetric: function(metricGR) {
var metricResultGR = new GlideRecord('asmt_metric_result');
var canDelete = true;
if (metricGR != null) {
if (metricGR.datatype == 'attachment') {
metricResultGR.addQuery('metric', metricGR.getUniqueValue());
metricResultGR.query();
var metricResultSysID = [];
while (metricResultGR.next()) {
metricResultSysID.push(metricResultGR.getUniqueValue());
}
var attachmentGR = new GlideRecord('sys_attachment');
attachmentGR.addQuery('table_name', 'asmt_metric_result');
attachmentGR.addQuery('table_sys_id', 'IN', metricResultSysID.join());
attachmentGR.query();
if (attachmentGR.hasNext())
canDelete = false;
} else {
var encodedQuery = 'metric.datatypeINdate,datetime,string^string_valueISNOTEMPTY^metric=';
encodedQuery += metricGR.getUniqueValue();
encodedQuery += '^NQmetric.datatype=reference^reference_value!=-1^metric=';
encodedQuery += metricGR.getUniqueValue();
encodedQuery += '^NQmetric.datatypeINchoice,imagescale,scale,multiplecheckbox,long,numericscale,percentage,ranking,template,boolean^actual_value!=-1^metric=';
encodedQuery += metricGR.getUniqueValue();
encodedQuery += '^NQmetric.datatype=checkbox^metric=';
encodedQuery += metricGR.getUniqueValue();
metricResultGR.addEncodedQuery(encodedQuery);
metricResultGR.query();
if (metricResultGR.hasNext())
canDelete = false;
}
}
return canDelete;
},
