To Display parent field value in child field

bumineela balan
Tera Contributor

Requirement:

1.There are two tables , parent table(sn_customerservice_case),child table (sn_customerservice_task)

2.Both have assigned_to field

3.When case is assigned to some one, it should also reflect the same in ,child table (assigned_to)

How can i achieve this in reference qualifier?

Thanks in advance

16 REPLIES 16

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

you can add advanced ref qualifier in Child table Assigned to field to show only those users which belongs to Case Assigned to

what did you try so far?

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Hi,

When case is created and assigned to some one, it should show by default in task (child table) 

Note: The same name which is in parent assigned_to field should be reflected in child assigned_to field.

what code should i enter  in advance reference qualifier

Hi,

you can use before insert BR on child table and set the assigned to by default

current.assigned_to = current.parent.assigned_to;

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

@bumineela balan 

Did you get a chance to check on my above script?

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader