Trying to map the metric question string value to the additional information field for report.

[Rhonda9]

Hello,

I created a custom report to get positive and negative responses.  The issue I am having is the customer wants to be able to view the string value of the question " Do you have any additional comments you would like to add" .  I have been able to create a BR to map the string value of the question to the additional comments field.  I would like the customer entry to be in the same for additional comments for all 5 questions for better viewing .

Please see attachment. 

I want "testing the survey" to be mapped to the additional information field or all 5 questions. 

[Vamsi Sreenivas]

Hi Rhonda,

are you looking to copy the string value of "Do you have any additional comments you would like to add" to all the questions under the survey in additional comments?

Can you share the BR/script that you have created?

Regards,

Vamsi S

[Rhonda9]

Yes, that is exactly what I'm trying to do.  Here is the BR.

[Vamsi Sreenivas]

Rhonda, so your BR is working as configured to set additional information with its string value of the same record.

If you are looking to update the set of questions under a survey with one question's string value then use below script in your BR.

BR Conditions:

Source is <YOUR SOURCE SYS ID> AND

Metric is " Do you have any additional comments you would like to add"

var grResult = new GlideRecord('asmt_metric_result');
grResult.addEncodedQuery("source="+current.source+"^sys_id!="+current.sys_id);
grResult.query();
while(grResult.next()) {
    grResult.add_info = current.string_value + " "+grResult.string_value + '';
    grResult.update();
}

Note: remove your existing 'Set field values' in BR.

Let me know if you have any questions.

Regards,

Vamsi S

[Rhonda9]

Thank  you for your help but this configuration caused my other business rule to stop working.  Now I got it working again.   

Did this need to change to an after BR?