- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-15-2021 04:07 AM
Hi All,
I've a record producer ("Request firewall Access") in scoped application "Firewall Audits" which will create a FTASK in a custom table (firewall_new_request). I've a MRVS in this record producer, on submitting a request from this record producer, all the rows which we're adding in MRVS will be available under parent table FTASK related list.
We've created another table (Rule resource data) to store all the MRVS values and we're setting the parent field of this child table from record producer script.
"""""" ruleresource.parent = current.sys_id.toString(); """""""
Query: I've a field called "Name" (String) in my record producer. After submitting the request from that record producer, I wanted to see the value which user entered in "Name" in child table (Rule Resource data) list view.
I wrote below before BR in child table by checking insert and update checkbox, but it is not working.
(function executeRule(current, previous /*null when async*/) {
var gr = new GlideRecord('sn_disco_firewall_new_firewall_request');
gr.addQuery('sys_id', current.parent);
gr.query();
if(gr.next()){
current.u_name = gr.u_name ;
current.update();
}
"u_name" is the backend field value for 'Name' in both parent and child table.
can anyone please some way to get the 'Name' value from parent table to child table 'name' field?
Note: Both tables extended from Task table.
Parent table field value:
Child Table field value is empty:
Please suggest a way to get the field value on child from parent.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-15-2021 08:18 AM
Hi,
is that field in same scope as that of table?
try this
current.u_name = current.parent.variables.u_name;
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
‎07-15-2021 08:18 AM
Hi,
is that field in same scope as that of table?
try this
current.u_name = current.parent.variables.u_name;
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
‎07-15-2021 08:25 AM
Hi Ankur,
Yes, all the fields are in same scope.
Please confirm whether you are asking me to try like this using 2nd script :
var gr = new GlideRecord('sn_disco_firewall_new_firewall_request');
gr.addQuery('sys_id', current.parent);
gr.query();
if(gr.next()){
current.u_name = gr.parent.variables.u_name;_rp ;
current.update();
}
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-15-2021 09:29 PM
Hi,
don't query directly do this with 1 line in BR
current.u_name = current.parent.variables.u_name;
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
‎07-15-2021 09:58 PM
Hi Ankur,
Thank you so much for your continuous help on this.
I updated my record producer script to map the variable directly to the child table and it is working now.
Thanks,
Nivetha K.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-15-2021 10:11 PM
Glad to help.
If my response helped please mark response as correct.
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader