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

[poornima batchu]

I'm trying to show all these fields in a single report but if I select task table in reports it is not showing up all the columns from hr tech table

[Jugmaz]

well you need to choose the hr tech (sn_hr_core_case_operations) table for the report!

[poornima batchu]

but the requirement is I need to show hr cases, Incidents, change requests and requested items in single report with all these columns

[Jugmaz]

ok, that explains.

What are the fields to be shown? IF they are specific to other table than TASK, then you would need DB View for it. If you have fields from Many different tables (Inc, chg etc.) then you would require quite complex view and that is once again not suggested.

so, what fields do you need to include in the report?

[poornima batchu]

I need create DB view with task table and hr tech table, but I'm struggling to write a exact where clause. Below mentioned fields are required