Auto Populate short description and description fields of a problem task from Template

[YamunaRaniK]

Hi Everyone,

I have a requirement to Auto populate Short description and Description fields of a Problem Task whose type is Risk Accepted (Like Root Cause Analysis) from a pre-defined template.

I tried using Business and Client script + script include but nothing is working as expected. 

I tried to query the fields of my template which is present in sys_template table in background script but nothing is coming as result.

Does anyone know the behavior of sys_template table, can anyone help me on this requirement.

Thanks in advance.

[Ankur Bawiskar · Accepted solution]

@YamunaRaniK 

I don't think it's a valid requirement to use script to set the fields when you can easily do this with templates.

But if you still require then you need to grab the encoded string from template, do string manipulation and then grab the short description and description and then set it

Something like this

var gr = new GlideRecord("sys_template");
gr.addQuery("name", "value");
gr.query();
if (gr.next()) {
    var input = gr.template.toString();

    var parts = input.split('^');
    var shortDescription = '';
    var description = '';
    for (var i = 0; i < parts.length; i++) {
        var keyValue = parts[i].split('=');
        if (keyValue[0] === 'short_description') {
            shortDescription = keyValue[1] || '';
        }
        if (keyValue[0] === 'description') {
            description = keyValue[1] || '';
        }
    }

    current.short_description = shortDescription;
    current.description = description;
}

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[YamunaRaniK]

Hi @Dr Atul G- LNG,

I am aware that when you apply a template the fields will mapped, that's OOB functionality .

But here my requirement is to auto populate the field values without applying (i.e, without clicking on the template).

@Ankur Bawiskar ,

I have attached the business rule like how I was trying to auto populate the fields.

Whatever the details I have given in template need to auto populate to the problem_task field while a task is creating, not by clicking on template to apply.

Hope the information is attained. 

Any suggestions on this requirement will be appriciated.

[Ankur Bawiskar · Accepted solution]

@YamunaRaniK 

I don't think it's a valid requirement to use script to set the fields when you can easily do this with templates.

But if you still require then you need to grab the encoded string from template, do string manipulation and then grab the short description and description and then set it

Something like this

var gr = new GlideRecord("sys_template");
gr.addQuery("name", "value");
gr.query();
if (gr.next()) {
    var input = gr.template.toString();

    var parts = input.split('^');
    var shortDescription = '';
    var description = '';
    for (var i = 0; i < parts.length; i++) {
        var keyValue = parts[i].split('=');
        if (keyValue[0] === 'short_description') {
            shortDescription = keyValue[1] || '';
        }
        if (keyValue[0] === 'description') {
            description = keyValue[1] || '';
        }
    }

    current.short_description = shortDescription;
    current.description = description;
}

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Dr Atul G- LNG]

Hi @YamunaRaniK 

Not a possible or valid case, mate. How will the system know which values to populate without the template? The values would differ each time. If you’re using a template, let’s fix the field values and use them accordingly. Don’t create technical debt for the system. 

[Syed14 · Accepted solution]

If you want to auto populate fields when form loads or any specific field changes, it can easily be achieved by using client script. According to your condition, set value of the description and short description fields on the form. Why are you using template?

If you need help in client script, let me know.