Is there a way to bring all the values of 'Change Request Value' field of Standard Template in list view for reposting purpose ?

[Dhara1]

Hello all,

For reporting purpose I need the all the values of standard change template in the list view but there is a field called Change Request Values which contain many other fields and this fields is not visible in list layout. Is there any other way to pull the values of this fields in list view or in reporting ?

[Muhammad Khan]

Hi Dhara,

I can help you find that column and add it to the list view. So, basically you are looking for it in std_change_record_producer table, there is a reference field called template which stores the reference of actual template you are looking for. See the below image for reference.

There is another table std_change_template which actually holds the fields and values in the same field called template, but here the type is Template Value, which you are looking for. See the below image for reference.

Hopefully, this will help you find the actual field you are looking for.

[Dhara1]

Hi Muhammad,

Thanks, this information definitely bring me close to what I am looking for. I can see short description in list view but I am also looking for more fields value which are description, Implementation plan, Backout plan ( which are exists under 'change request values' field) which I am targeting for and I don't see those fields. How do I find those fields value?

Thanks,

Dhara

[Muhammad Khan · Accepted solution]

@Dhara, If you hover over on the value of that column, you will find all the fields along with their values, separated by ^ character.

[Jan Janou_ek]

Hello Muhammad,

is it possible to change values of those fields by script? We have an item called "Standard change proposal" if users want to ask for a new standard change from Service Portal. My point is to copy values from this RITM after it is validated to Standard Change Proposal template but I dont know how to insert. Script below doesnt work I still get only default values on a new STDCHG ticket. Thank you!

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

	var proposal = current;
	var template = new GlideRecord('std_change_proposal');
	template.initialize();
	template.description = "Created after Proposal validation";
	template.business_justification = "Nobody wants to do it manually";
	template.short_description = proposal.variables.template_name;
	template.template_value.category = proposal.variables.change_category;
	template.template_value.short_description = proposal.variables.template_name;
	template.template_value.Description = proposal.variables.description;
	template.template_value.implementation_plan = proposal.variables.change_implementation_plan;
	template.template_value.backout_plan = proposal.variables.change_rollback;
	template.template_value.test_plan = proposal.variables.change_test_plan;
	template.template_value.justification = proposal.variables.change_justification;
	template.template_value.risk_impact_analysis = proposal.variables.risk_and_impact_analysis;
	template.template_value.assignment_group = proposal.variables.change_assignment_group;
	template.template_value.chg_model = 'e55d0bfec343101035ae3f52c1d3ae49';
	template.insert();

})(current, previous);

edit: I tried to do it with Flow designer but I am not able to set Change request values there too.

---