CREATE view  View_Issue AS SELECT issue.*, issstat.sym status_name, pri.sym priority_num, isscat.sym category_name, int_org.org_name organization_name, affected_usr.last_name affected_end_user_lastname,
affected_usr.first_name affected_end_user_firstname, affected_usr.middle_name affected_end_user_middlename, assignee.last_name assignee_lastname, assignee.first_name assignee_firstname, assignee.middle_name assignee_middlename, View_Group.contact_uuid groupID,
View_Group.last_name group_name, srv_desc.sym service_type, impact.sym impact_num, product.sym product_sym, toc.sym type_of_contact_sym, repmeth.sym rpting_method_sym, perscon.sym person_contacting_sym, interface.sym created_via_sym, rootcause.sym rootcause_sym
FROM ((((((((((((((( issue inner join  pri ON issue.priority = pri.enum)
left join  issstat ON issue.status = issstat.code)
inner join  ca_contact affected_usr ON issue.requestor = affected_usr.contact_uuid)
left join  ca_contact assignee ON issue.assignee = assignee.contact_uuid)
left join  srv_desc ON issue.support_lev = srv_desc.persid)
left join  ca_organization int_org ON issue.organization = int_org.organization_uuid)
left join  isscat ON issue.category = isscat.code)
left join  View_Group ON issue.group_id = View_Group.contact_uuid)
left join  impact ON issue.impact = impact.enum)
left join  product ON issue.product = product.id)
left join  toc ON issue.type_of_contact = toc.id)
left join  repmeth ON issue.reporting_method = repmeth.id) left join  perscon ON issue.person_contacting= perscon.id) left join  interface ON issue.created_via = interface.id) left join  rootcause ON issue.rootcause = rootcause.id)
GO
GRANT SELECT ON  [dbo].[View_Issue] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[View_Issue] TO [service_desk_ro_group]
GO