Database Views table that links the HR task table and the Parent field

[Amy13]

I'm trying to create a report that starts at the HR task table and shows information from the Parent field on the form (which links to the case). Can't dotwalk from the HR task through the Parent field to the fields on the Parent form, so I would have to create a database views table. How would I update the Where clause below to be able to dotwalk through the Parent field on the task record?

[Mohith Devatte]

A re you able to see the HR profile records when you hit try it ?

[Amy13]

Yes I can!! I am trying to show the subject person on the HR case on the same list as the HR task. I'm still not seeing how I can do that. When I try to add Parent (hrt) and dotwalk to subject person, I still can't see that field.

[Mohith Devatte · Accepted solution]

Hey Amy,

I think now i got your requirement !

Its not possible to get the subject person field which is on the HR case form and technically that HR case is a parent to that HR task .

So if you go to HR task table parent field would be referring to Task table so if you try to dot walk it will give you task table fields as it is referring to it.

If the parent field was referring to HR case then it would have been easy for you to dot walk from hr task -->hr case-->subject person .

Please accept the solution if you understood the limitation and close the thread this might help others too if they have the same query

[Amy13]

But if I open up the Parent field on the HR task record, it directs me to the related HR Case on the sn_hr_le_case table right? Then in theory, I should be able to dotwalk to the Subject person ?

[Mohith Devatte]

Hello,

Yes it takes us to HR Case record because HR case extends task table and it is one of the task type. 

So technically its a type of task but not exactly the HR case that you are seeing

Please mark my answer helpful if you got any help with it