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

Amy13 · ‎07-06-2022

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 · ‎07-06-2022

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

View solution in original post

faro · ‎03-17-2023

This can be achieve without database view. I'm in San Diego version > Reports

then scroll down, to see Extended Fields

..and here it is what you are after I believe: