View ocum.annotationresourceobjectlivelistdtoview | Generated by SchemaSpy |
View Definition:
select `ocum`.`annotation`.`name` AS `annotationName`,`ocum`.`annotationtype`.`name` AS `annotationTypeName`,`ocum`.`annotationresourceobject`.`resource_id` AS `resourceId`,`ocum`.`annotationresourceobject`.`resource_type` AS `resourceType`,coalesce(`cluster`.`name`,`volume`.`name`,`vserver`.`name`) AS `resourceName` from (((((`ocum`.`annotationresourceobject` left join `netapp_model_view`.`cluster` on(((`ocum`.`annotationresourceobject`.`resource_id` = `cluster`.`objid`) and (`ocum`.`annotationresourceobject`.`resource_type` = 'cluster')))) left join `netapp_model_view`.`volume` on(((`ocum`.`annotationresourceobject`.`resource_id` = `volume`.`objid`) and (`ocum`.`annotationresourceobject`.`resource_type` = 'volume')))) left join `netapp_model_view`.`vserver` on(((`ocum`.`annotationresourceobject`.`resource_id` = `vserver`.`objid`) and (`ocum`.`annotationresourceobject`.`resource_type` = 'vserver')))) straight_join `ocum`.`annotationtype` on((`ocum`.`annotationtype`.`id` = `ocum`.`annotationresourceobject`.`annotationType_id`))) straight_join `ocum`.`annotation` on((`ocum`.`annotation`.`id` = `ocum`.`annotationresourceobject`.`annotation_id`)))
Possibly Referenced Tables/Views: