When making a report, how do I dot-walk to all parent table fields?

Shant Cancik
Tera Contributor

I'm experiencing some strange behavior. I have 2 tables (both extended from   the Task table.

Table 1) Requirement

Table 2) Requirement Tasks

Table 1 is the parent of Table 2 and I am currently making a report on Table 2 (Requirement Tasks). I want to add fields to my report that are on Table 1 and I tried to do this by dot-walking into the "Parent" fields through the field selector area. If I add "Parent" to my report I do see the right record (I.e REQ00008) but when I dot-walk into it I don't get have the ability to add the custom fields I created on Table 1. I just saw standard table fields as option (ie. updated, submitted by, etc).

Anyone know what I'm doing wrong?

-Shant

4 REPLIES 4

sachin_namjoshi
Kilo Patron
Kilo Patron

Please check below which may help you



Selecting fields on related tables using dot-walking



Regards,


Sachin


Hey Sachin,



Yes, I'm dot-walking in a list collector but not all parent fields appear which is surprising. Just the default parent fields appear and none of my custom made ones. Very strange.


samuelscott
Tera Expert

I'm having the exact same problem...I didn't find the link useful, is there a solution to this?

ericcrawford
ServiceNow Employee
ServiceNow Employee

Did either of you figure this out?  

sachin.namjoshi's points attempt was not helpful.