Dotwalk from task table to child table fields ex. (change_request)

Tadz
Kilo Sage
Kilo Sage

Hi Everyone,

Is it possible to dotwalk from task table to change_request table.

Example:

I have a field called Parent Record which is referenced to task table so that i can select a record from Incident, Problem, Change and etc.

Problem is, when i try to do a filter on a change record. The fields from change record is not available in the list.

I believe you can only dotwalk from child to parent. 

 

Is there a way to make that possible? 

Thanks,

Tadz

1 ACCEPTED SOLUTION

Hi,

please check this property -> glide.ui.list.allow_extended_fields

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

https://sn.jace.pro/docs/properties/glide.ui.list.allow_extended_fields/

https://community.servicenow.com/community?id=community_question&sys_id=7b7cf027db2c04d0feb1a851ca96...

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

9 REPLIES 9

johnfeist
Mega Sage
Mega Sage

Hi Tadz,

change_request extends task.  You can access any record that extends task from task,  There is a column Task Type (sys_class_name) that tells you the table where the full record resides.  If you filter on that basis you should be able to get records from any table that extends task.  Keep in mind that this may require filter criteria beyond simple.

Hope that helps.

:{)

Helpful and Correct tags are appreciated and help others to find information faster

Hope that helps.

:{)

Helpful and Correct tags are appreciated and help others to find information faster

Hi John, yes but what I want to access change_request fields from task. And I can't seem to dotwalk from Task type to Change Request fields. 

 

 

Hi Tadz,

If you're looking to have related lists attached to a record, you will need to have separate tabs for each type because going directly to task will only show the fields in that table. You can get tricky with list controls to only show tabs that are populated.

If you are looking to have a script get to the fields, you need to do something like this:

//assumes that you have the task record available in theTask
var fullRecord = new GlideRecord(theTask.sys_class_name);
fullRecord.get(theTask.sys_id);

From there you have full access to the incident, change, problem, etc.  The bottom line is that while in the context of task, you can only access task level data.

If you will need to display different data based on the task type you are probably best creating the relevant client scripts that do AJAX calls to fetch the data.  From there you can populate various fields as needed.

Hope that helps.

:{)

Helpful and Correct tags are appreciated and help others to find information faster

Hope that helps.

:{)

Helpful and Correct tags are appreciated and help others to find information faster

Hi,

please check this property -> glide.ui.list.allow_extended_fields

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

https://sn.jace.pro/docs/properties/glide.ui.list.allow_extended_fields/

https://community.servicenow.com/community?id=community_question&sys_id=7b7cf027db2c04d0feb1a851ca96...

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader