Database view - union

[gkr]

Hi All,

I am looking to Union 3 DB   tables (incident, problem, change_request) to get the joint result set with common fields. I would appreciate if you can guide me in right direction.

Thanks,

[Terje Nilima Mo]

One thing you do not get with the task table is the ability to have IncidentState and RequestState in the same column, and there are states in the state table of task that is not compatible between incident and request. Therefore this is not a desired solution.

[Rafal Rataj1]

I am also looking for a UNION solution for custom mapping tables 

-one maps support groups 

- second maps support users ( not from those groups) 

so I do not see any union solution in ServiceNow

(except gl.sql and other scipting solutions but this is not designed for reportig ) 

in case you want to report on inc/change/req 

go to tables module and look what tables they are extending - in this case the task table 

so you can easily build a report on task table for all extended task types and then (with the extended attibutes enabled  )  you can select attibutes from the child classes 

so in a report on task table you can add change,scheduled on time, incident.isMajorIncient and so on..

database view join is not a union