creating database view connecting task table and sn_hr_core_case_operations table

[poornima batchu]

hi all, 

I'm trying to create DB view containing both task table coloumns and hr tech (sn_hr_core_case_operations) table. I need pull all tickets dump. what is where clause I need to apply here ?

please give solutions

[Jugmaz]

you don't need that, if you create report against the HR Tech table, you have all the fields there available.

if you need Incident, change and others as well, then you need to create DB view between inc and hr tech - which needs also something to connect them together...

What is your exact requirement for this?

show hr cases, Incidents, change requests and requested items in one report ? or something else?

[poornima batchu]

I need to show inc, requested items, hr tech cases, change requests with all these columns in a single report

[Ankur Bawiskar]

on which basis you are joining this HR table with incident, change, RITM?

[poornima batchu]

I need to display all these columns mentioned above in single report and it also contains itsm tickets, ritm, hr tickets and change requests.

[poornima batchu]

there is no particular condition i need to display all cases from the task table containning incidents, requested items and change requests and hr tech cases