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

Amy13 · ‎07-06-2022

I've reattached it!

Mohith Devatte · ‎07-06-2022

Hello Amy,

Please change the order of HR task view table to 200 a

use below clause in HR task view table

hrt_parent=hrc_sys_id

remove the clause in HR case view table.

Can you please try this and let me know

please accept the solution if it answers your question

Amy13 · ‎07-06-2022

Thank you! I've gotten the DB views table; however, I still have an issue. I've set up the DB columns the same as the ones on the HR task table. I can dotwalk from the HR task table to the parent field (HR case), but I cannot get from there to the HR profile through the subject person. Do I need to create a new line item with a new where clause for HR profile?

Mohith Devatte · ‎07-06-2022

Hey Amy ,

Yes you need to add one more view table to to the list which is for HR profile table

and the where clause should be linked to HR case view table

Create another view table with order 300 , prefix as hrp and where clause as below

hrp_user = hrc_subject_person

please accept the solution of it helped you

Amy13 · ‎07-06-2022

Sorry, I did add the 3rd item, but I'm still struggling to dotwalk from the HR task --> parent --> subject person successfully. How would we dot walk there?