get value from parent table to child table

[Akash68]

Hi,

in project table i have a field called "it segment".if that i"t segment" is equal to "xyz" then only i need to set some  values in child table(decision) like short description to "test"and approval required to yes

Please find the scripts used:

client script:table:Decission

function onLoad() {
//Type appropriate comment here, and begin script below
var itsegement=g_form.getValue("it_segments");------>it is in parent table
alert(itsegement);
var ga = new GlideAjax('SetValuesforITSDProject');-->my script include
ga.addParam('sysparm_name','myfunction');
ga.addParam('sysparm_user_name',g_form.getValue("it_segments"));
ga.getXML(setValue);
function setValue(response)
{
var answer = response.responseXML.documentElement.getAttribute("answer");
alert(answer);
g_form.setValue("short_description",answer);
g_form.setValue("approval_required",'yes');
}}

script include:

var SetValuesforITSDProject = Class.create();
SetValuesforITSDProject.prototype = Object.extendsObject(global.AbstractAjaxProcessor, {
myfunction: function() {
var name = this.getParameter('sysparm_user_name').toString();
return "test";}

});

kindly help here. Thanks in advance!

[Akash68]

Hi David,

The above code is not working. And also when ever we click on new(child ticket), logic should get triggered, not only first time.

Thanks

[Dubz]

OK add in some debug messages:

function onLoad() {
alert(g_form.getValue("parent"));
var ga = new GlideAjax('SetValuesforITSDProject');-->my script include
ga.addParam('sysparm_name','myfunction');
ga.addParam('sysparm_parent',g_form.getValue("parent"));
ga.getXML(setValue);
function setValue(response)
{
var answer = response.responseXML.documentElement.getAttribute("answer");
alert(answer);
g_form.setValue("short_description",answer);
g_form.setValue("approval_required",'yes');
}
}

var SetValuesforITSDProject = Class.create();
SetValuesforITSDProject.prototype = Object.extendsObject(global.AbstractAjaxProcessor, {

myfunction: function() {
var parent = this.getParameter('sysparm_parent');
gs.log(parent);
var gr = new GlideRecord('pm_project');
if(gr.get(parent)){
gs.log('script include got here and segment is: ' + gr.it_segments.getDisplayValue());
return gr.it_segments.getDisplayValue(); 

}

});

Confirm what is being returned in both alerts and both gs.logs

Also, check all table names and field names, the syntax should be correct but only you know the correct field and table names.

[Akash68]

Hi David,

I am not getting any alerts or logs.

Thanks

[Dubz]

OK just realised, when you open a new decision form the parent field will be blank so it'll have nothing to go on. You'll need to run this onChange of the parent field, if the it segment is going to change on the parent form you'll need to have an after update business rule running on that to update child records when the value changes.

[Akash68]

 it is returning sys_id of project(parent)