View ocum_report_birt.eventstatecharthelper | Generated by SchemaSpy |
View Definition:
select `eventupdatedates`.`lastUpdatedTime` AS `lastUpdatedTime`,if(isnull(`newevents`.`eventsCount`),0,`newevents`.`eventsCount`) AS `newCount`,if(isnull(`ackevents`.`eventsCount`),0,`ackevents`.`eventsCount`) AS `ackCount`,if(isnull(`acktoresolvedandobsoleteevents`.`eventsCount`),0,`acktoresolvedandobsoleteevents`.`eventsCount`) AS `ackToResolvedAndObsoleteCount`,if(isnull(`newtoresolvedandobsoleteevents`.`eventsCount`),0,`newtoresolvedandobsoleteevents`.`eventsCount`) AS `newToResolvedAndObsoleteCount` from ((((`ocum_report_birt`.`eventupdatedates` left join `ocum_report_birt`.`newevents` on((`eventupdatedates`.`lastUpdatedTime` = `newevents`.`lastUpdatedTime`))) left join `ocum_report_birt`.`ackevents` on((`eventupdatedates`.`lastUpdatedTime` = `ackevents`.`lastUpdatedTime`))) left join `ocum_report_birt`.`acktoresolvedandobsoleteevents` on((`eventupdatedates`.`lastUpdatedTime` = `acktoresolvedandobsoleteevents`.`lastUpdatedTime`))) left join `ocum_report_birt`.`newtoresolvedandobsoleteevents` on((`eventupdatedates`.`lastUpdatedTime` = `newtoresolvedandobsoleteevents`.`lastUpdatedTime`))) group by `eventupdatedates`.`lastUpdatedTime`
Possibly Referenced Tables/Views: