question Re: how to display value of variable having different data types like number,string,images,date & in ITSM forum

how to display value of variable having different data types like number,string,images,date &time et

chaitanyakumarD — Fri, 05 Jan 2024 09:53:19 GMT

i triggered a survay once a RITM is closed and those answers i want to capture in additional comments but it is storing only backend values for answers . can any one correctme in the code which i have written

(function executeRule(current, previous /*null when async*/ ) {

var assessmentResponses = [];

var assessmentQuestionGR = new GlideRecord('asmt_assessment_instance_question');

assessmentQuestionGR.addQuery('instance', current.sys_id);

assessmentQuestionGR.addQuery('valueISNOTEMPTY');

assessmentQuestionGR.query();

while (assessmentQuestionGR.next()) {

var question = assessmentQuestionGR.metric.getDisplayValue(); // Use getDisplayValue() for reference fields

var answer = assessmentQuestionGR.value.toString(); // Replace 'value' with the actual field name for the answer

assessmentResponses.push({

question: question,

answer: answer

});

}

// Update RITM Additional Comments with assessment responses

var ritm = new GlideRecord('sc_req_item');

if (ritm.get('sys_id', current.task_id)) {

var additionalComments = "\nAssessment Responses:\n";

for (var i = 0; i < assessmentResponses.length; i++) {

additionalComments += assessmentResponses[i].question + ': ' + assessmentResponses[i].answer + '\n';

}

ritm.comments += additionalComments;

ritm.update();

}

})(current, previous);

Re: how to display value of variable having different data types like number,string,images,date &

Ivan Betev — Sun, 07 Jan 2024 14:49:46 GMT

Hello there,

some metrics like "Date", "DateTime", and "String" store their values in the String value (string_value) field, you can try grabbing that one.

As for the ones that have a "Metric Definition" table behind them, you can try something like this:

(function executeRule(current, previous /*null when async*/) { var assessmentResponses = []; var assessmentQuestionGR = new GlideRecord('asmt_assessment_instance_question'); assessmentQuestionGR.addQuery('instance', current.sys_id); assessmentQuestionGR.addQuery('valueISNOTEMPTY'); assessmentQuestionGR.query(); while (assessmentQuestionGR.next()) { var question = assessmentQuestionGR.metric.getDisplayValue(); // Use getDisplayValue() for reference fields var metricDefGr = new GlideRecord('asmt_metric_definition'); metricDefGr.addQuery('metric', assessmentQuestionGR.metric); metricDefGr.addQuery('value', assessmentQuestionGR.value); metricDefGr.query(); var answer = metricDefGr.next() ? metricDefGr.display : ""; assessmentResponses.push({ question: question, answer: answer }); } // Update RITM Additional Comments with assessment responses var ritm = new GlideRecord('sc_req_item'); if (ritm.get('sys_id', current.task_id)) { var additionalComments = "\nAssessment Responses:\n"; for (var i = 0; i < assessmentResponses.length; i++) { additionalComments += assessmentResponses[i].question + ': ' + assessmentResponses[i].answer + '\n'; } ritm.comments += additionalComments; ritm.update(); } })(current, previous);

BUT, you need to get rid of the nested call first (e.g. by using a prefetch), as it's a bad practice for performance.

Regards, Ivan

Re: how to display value of variable having different data types like number,string,images,date &

Tai Vu — Mon, 08 Jan 2024 04:32:06 GMT

Hi @chaitanyakumarD

Typically, the Display value of the Metric (Question) is stored in the String Value field as per the Assessment Metric Definitions. But within the Assessment Instance Questions [asmt_assessment_instance_question] table currently used from your script, the String Value field is not fully populated.

You can try to pull data from the Metric Result [asmt_metric_result] table instead. This way, you can retrieve the answer along with the display value through the String Value field.

So your script could be like sample below.

(function executeRule(current, previous /*null when async*/ ) { var assessmentResponses = []; var assessmentQuestionGR = new GlideRecord('asmt_metric_result'); //replace the table assessmentQuestionGR.addQuery('instance', current.sys_id); assessmentQuestionGR.addNotNullQuery('actual_value'); //replace the field name //assessmentQuestionGR.addQuery('valueISNOTEMPTY'); assessmentQuestionGR.query(); while (assessmentQuestionGR.next()) { var question = assessmentQuestionGR.metric.getDisplayValue(); var answer = assessmentQuestionGR.string_value.toString(); //replace to string_value assessmentResponses.push({ question: question, answer: answer }); } // Update RITM Additional Comments with assessment responses var ritm = new GlideRecord('sc_req_item'); if (ritm.get('sys_id', current.task_id)) { var additionalComments = "\nAssessment Responses:\n"; for (var i = 0; i < assessmentResponses.length; i++) { additionalComments += assessmentResponses[i].question + ': ' + assessmentResponses[i].answer + '\n'; } ritm.comments += additionalComments; ritm.update(); } })(current, previous);

Cheers,

Tai Vu

Re: how to display value of variable having different data types like number,string,images,date &

chaitanyakumarD — Mon, 08 Jan 2024 10:17:36 GMT

hi I have tried that also but it is not populating the results as desired even they are not reference fields also

thankyou for your response

Re: how to display value of variable having different data types like number,string,images,date &

Tai Vu — Mon, 08 Jan 2024 10:35:36 GMT

Hi @chaitanyakumarD

For better understanding of the specific challenges you're encountering, can you provide more information in your business rule? Table, when to run, your advanced script, etc.

Cheers,

Tai Vu

Re: how to display value of variable having different data types like number,string,images,date &

chaitanyakumarD — Fri, 12 Jan 2024 02:48:41 GMT

thank you timi thats working fine and i have done similar changes only now its working fine .

now i have another qustion

there is screen short captured in the answers , i wnt that to populate it on same RITM additional comments as a link so that whenever we click the link i want show a preview of that snippet to be viewed how can we acheive this ,?

Re: how to display value of variable having different data types like number,string,images,date &

Tai Vu — Mon, 15 Jan 2024 04:27:12 GMT

Hi @chaitanyakumarD

You can leverage the GlideSysAttachment API to retrieve the associated attachments of the question.

Then you can build a reference link to open the attachment viewer.

Sample below.

Based on the script I provided before, let add an exception in the while loop.

Enjoy your result

Make sure you have enabled Document Viewer in the table.

Ref: Enable Document Viewer

Cheers,

Tai Vu