There may be another way around this problem, but I had considerable grief trying to set up survey assessments for specific records in the contracts module. After trawling through the docs and trying to manually generate assessments and manually send, I still couldn't get the damn thing to work and kept getting the "noquestions" error, so I came up with a script that ensures surveys/assessments are sent.
Step 1: Set up your survey or assessment metric type as normal
Make sure you have your questions, etc in the related list for Metric Categories but don't schedule the survey. Leave it set to on demand and we'll set up our own scheduled job.
Step 2: Run a scheduled job to cycle through your accessible records
Strictly speaking, this shouldn't be necessary, but nothing was sending overnight so I wrote this to make sure all the component parts were in play.
var whichAssessment = '2349ed57dbbc4c103ea3cd0514961909';//<<<--- update with the sys_id of your assessment metric type
var thisAssessment = new GlideRecord('asmt_metric_type');
if(thisAssessment.get(whichAssessment)){
////////////////////////////////////////////////////////////////////////
//create the assessible records
(new SNC.AssessmentCreation()).createAssessableRecords(thisAssessment);
////////////////////////////////////////////////////////////////////////
//check to make sure they have questions attached
var categories = [];
var getCategories = new GlideRecord('asmt_metric_category');
getCategories.addEncodedQuery('metric_type.sys_id=' + whichAssessment );
getCategories.query();
while(getCategories.next()){
categories.push(getCategories.sys_id.toString());
}
//To avoid the noquestions error, look at all the assessible records and make sure questions are attached
var checkAssessableRecords = new GlideRecord('asmt_assessable_record');
checkAssessableRecords.addEncodedQuery('metric_type.sys_id=' + whichAssessment);
checkAssessableRecords.query();
while(checkAssessableRecords.next()){
var assessibleCategories = new GlideRecord('asmt_m2m_category_assessment');
if(!assessibleCategories.get('assessment_record.sys_id',checkAssessableRecords.sys_id)){
categories.forEach(function(assessCategory){
var newAssessCategory = new GlideRecord('asmt_m2m_category_assessment');
newAssessCategory.initalize();
newAssessCategory.assessment_record = checkAssessableRecords.sys_id;
newAssessCategory.category = assessCategory;
newAssessCategory.insert();
});
}
}
////////////////////////////////////////////////////////////////////////
//create and send the assessments
var thisRecord = new GlideRecord(thisAssessment.table);
thisRecord.addEncodedQuery(thisAssessment.condition);
thisRecord.query();
while(thisRecord.next()){
(new SNC.AssessmentCreation()).createAssessments(whichAssessment, thisRecord.sys_id.toString(), thisRecord.contract_administrator.sys_id.toString());
}
}You can find the documentation for AssessmentCreation and functions such as createAssessments and createAssessibleRecords on the ServiceNow Developer API
Have fun
I've been through this same issue before and looking at your code I see you had the same issue that I saw, the Metric Categories weren't attached to the Assessment.
I can't explain why it is built this way, but you MUST have a filter on your Metric Category for it to attach to the Assessment. This can be the same criteria as the Assessment itself. It makes no sense, but without it it will not generate.
An example here is for a Performance Review.
@krr you are right.
If the Assessment Category filter is empty, the "Evaluate filters" BR [sys_id=4c021c56d7b00100fceaa6859e6103f7] does not create records in the "asmt_m2m_category_assessment" once a record in the "asmt_assessable_record" table is created.
The issue is also described here: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0752930
