logo

NJP

Unable to add dot walked fields from child tables in Next Experience UI

Import · Mar 29, 2023 · article

Unable using the UI slushbucket to add a field that is only defined at a child table from the reference. In this case CI to Asset (but an attribute on the child table of alm_hardware)

Screen Shot 2023-03-29 at 1.04.27 PM.png

Update the record using background script/fix script. Below is a coding example.

var gr = new GlideRecord('sys_ux_list')
if(gr.get('c4f09bdc0781201019cc909f0ad30076')){
var columns = gr.columns;
var updatedColumns = columns + ',configuration_item.asset.ref_alm_hardware.u_test_attribute_at_child_table';
gr.columns = updatedColumns;
gr.update();
}

Please upvote this idea on the idea portal to make this capability native without the use of scripts.

Adapted from https://www.servicenow.com/community/developer-forum/problem-with-dot-walking-and-extended-table/m-p...

View original source

https://www.servicenow.com/community/app-engine-articles/unable-to-add-dot-walked-fields-from-child-tables-in-next/ta-p/2520744