Notifications

7 views

Symptoms


Change request fields are not showing up in data picker. Some of the change form related fields are not showing up.
Fields like start_date, end_date are not present.

 

Resolution


Please note the 'Parent' field is a reference to 'task' table, not 'change_request'. The columns mentioned Planned start date (start_date)/Planned end date (end date) are columns on the change_request table. This can be seen at the following link. Please expand the change_request table on the schema: 

<Instance name>.service-now.com/nav_to.do?uri=%2Fgeneric_hierarchy_erd.do%3Fsysparm_attributes%3Dtable_history%3D,table%3Dtask,show_internal%3Dtrue,show_referenced%3Dtrue,show_referenced_by%3Dtrue,show_extended%3Dtrue,show_extended_by%3Dtrue,table_expansion%3D,spacing_x%3D60,spacing_y%3D90,nocontext 

From this we can see these columns do not exist on the task table, but rather the child table change_request. In this case, from change_task you will need to dot walk through the 'Change request' field which references change_request table. 

 

Article Information

Last Updated:2018-11-30 13:06:56
Published:2018-11-30