To Display parent field value in child field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-06-2022 10:43 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-06-2022 10:59 PM
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
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-06-2022 11:04 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-06-2022 11:22 PM
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
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-07-2022 01:39 AM
Did you get a chance to check on my above script?
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader