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

Jaspal Singh · ‎07-06-2022

Yes, you would need HR Profile to be added as well.

So, do below.

1. Add HR Profile table with variable hrp & with order 300 & where condition as

hrp_user=parent_subject_person

Amy13 · ‎07-06-2022

Apologies, the condition hrp_user=parent_subject_person didn't work. I also tried hrp_user=hrt_parent_subject_person and that didn't work as well.

Jaspal Singh · ‎07-06-2022

hrp_user=parent_subject_person was a typo

Use

hrp_user=hrc_subject_person

Amy13 · ‎07-06-2022

Thanks! I've got the table; however, I can't seem to dotwalk from the HR task --> Parent field (which opens up the related HR case on th sn_hr_le_case table) --> Subject person? Would you happen to know how to do this?

Mohith Devatte · ‎07-06-2022

hello,

Can you share the image as an attachment so that i can guide you on where clause