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 are having some weird requirement as i would imagine that one might need a Report containing all the cases but without process specific fields, that is possible straight from TASK. While report which includes Incident and Request are something that MIGHT be in same report but i cannot see any benefit combining HR cases with Requests and with their own fields.

but, if you follow the video provided and create DB View with all different tables, you should be able to do one BUT they don't have anything in common, they are just long list of records that does have different fields.

[poornima batchu]

Hi Jake,

Thanks for responding to my replies.

Straight from the Task table I can see all the cases which Includes hr tech, incidents, ritm, change requests. But I cannot be able to add these fields( hr system, hr service...) as these are from hr tech table. I need to show up these fields in the same report but if I run report only on task table, these (hr system, hr service) fields not showing up

I think there is only way I can show up these fields using DB view but I'm struggling to find the where clause without any condition just to show up all fields in single list

[Amit Gujarathi]

HI Poornima,

Hope you are doing fine.

Please find the below video on database view creation . It will help.

Regards,

Amit Gujarathi