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

Hi Amy,

Image is broken. Can you share image again.

Additionaly considering you are using HR Case & HR Task for database view you need something as below for HC Task table where clause

hctask.parent=hccase.sys_id

where hctask is variable name for HC task view you used & hccase is variable name for HR Case

Amy13 · ‎07-06-2022

I've reattached it!

Jaspal Singh · ‎07-06-2022

Thanks. Do below

1. change the order for HR Task to 200 & for HR Case to 100

2. Remove where clause for HR Case & leave it empty

3. Update where clause for HR Task as

hrt_parent=hrc_sys_id

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?