Hi Abdul,
Try the script below.
A few points to note:
1. I did not use advance reference qual in Annu or in Ayesha, so if you have any, you can remove them.
2. adding more than one parent to Annu field will not update Ayesha with the new records.
3. removing a parent from the Annu field will not remove child records from Ayesha; it can probably be done - I do not know how.
However, adding two parent values to Annu will show the first value's added children in Ayesha. Then, removing the first value from Anu (the one that displays the children) will show in Ayesha the second value's children.
4. both of my fields - Annu and Ayesha - refer to the service offering table. Therefore, the records they show are the display records (name) from the Service Offering table. I do not know of a way to show the parent field display value in Annu, and the child record name in Ayesha when they are both list fields on the same table. If a list field is not a must, we can create a drop down that references the parent from Service Offering.
Here is the onChange script for Annu:
function onChange(control, oldValue, newValue, isLoading, isTemplate) {
if (isLoading || newValue === '') {
return;
}
//Type appropriate comment here, and begin script below
var annu = g_form.getValue('u_annu');
var tfm = new GlideRecord('service_offering');
tfm.addQuery('sys_id', annu);
tfm.query();
while(tfm.next()) {
var list = tfm.parent;
var array = list.split(',');
for(var i=0; i<array.length;i++) {
var p = new GlideRecord('service_offering');
p.addQuery('parent', array[i]);
p.query();
p.query(getMeTheNames);
}
}
}
function getMeTheNames(p) {
var list = new Array();
while (p.next()) {
list.push(p.sys_id);
}
g_form.setValue('u_ayesha', list);
}
harel
Please mark as correct or helpful as needed.
