Create databse view for Task, RITM, Catalog task, HR Case

[Pradeep67]

Hello,

Is it possible to create DB view to join Task, RITM, Catalog task and HR case table.

I tried with Task, RITM and Catalog task and it is working, since it has parent-child relationship. but how to include HR cases into this.

[Nilesh Pol]

Hi @Pradeep67 

Can you verify HR Case table (sn_hr_core_case) can be joined to the Task table (task) using the hr_case reference field? 

[Pradeep67]

Hi Nilesh,

I did not get you

hr_case reference field, is this in task table? I did not find anything as such field.

If you are talking about direct task and HR Case join, task_sys_id=hr_case_sys_id, this is not working

[Ankur Bawiskar]

@Pradeep67 

you can include HR case as well if you are populating parent field of HR case with either REQ or RITM

what's your use-case?

Will RITM parent field hold HR case or vice-versa?

Answer to above question will help you to create the database view accordingly.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Pradeep67]

Hello Ankur,

No I dont want to populate HR case in RITM or vice-versa.

Use case, I need a consolidated report which shows RITM, Catalog and HR cases in one single report.

Is it possible, if tables dont have any relationship apart from that they are extended from task table?