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.

[Ankur Bawiskar]

@Pradeep67 

unless you have a relationship between them OR have some common field you can't create database view.

Since you said you won't be populating anything in either of the records then do you want to see the RITMs where Requested For == HR Case -> Subject person

If yes then you can join

If not then what's your business requirement, please discuss with customer

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