Is it possible to bring columns on incident table on task list?

[prasanna11]

Just like the property "glide.ui.list.allow_extended_fields" to filter base tables with extended table's fields,

Is it possible to bring the incident table specific columns on task table list?

Or in simpler terms, Can i bring priority column (incident specific) in task.list ? (without building database view) ?

[shloke04]

Hi,

OOB behavior does Not allow the field created on the Child Table like Incident to be made available in the List or any other View on the Parent Table like the Task Table.

If there is any specific field you have created on the Child Table(Incident) and Now you want to make the field available on the Task Table then the only solution would be to Move your Custom field created on the Incident table to the Task Table using the Below script.

You need to run this in Background Script:

GlideDBUtil.promoteColumn('table_to_move_from', 'table_to_move_to', 'field_to_move', true);

For Example I had to move the Field Impact1 from Incident to task Table then I can write the code as below;

GlideDBUtil.promoteColumn('incident', 'task', 'u_impact1', true);

So once this Script is Run in the Background Script, The field will be moved from Incident to Task allowing you to make it available in the Task List View.

You can Refer the Below link on the same for more details on above API:

https://www.servicenowguru.com/scripting/promote-field-extended-table-servicenow/

Note: Please try the above script in Non-Production instances like Dev or Test, and then if it works fine without any issue then you can try this on your Production instance.

Hope this helps.Mark the answer as correct/helpful based on impact.

Regards,

Shloke

[prasanna11]

Hi Shloke,

If we promote the child table column to parent, we may get performance issue right?

[Bart19]

This method doesn't work anymore. Function it's blacklisted. 

https://hi.service-now.com/kb_view.do?sysparm_article=KB0743116