View ocum_report_birt.daywiseeventstatustrendchart | Generated by SchemaSpy |
View Definition:
select `helper1`.`lastUpdatedTime` AS `lastUpdatedTime`,(sum(`helper2`.`newCount`) - (sum(`helper2`.`ackCount`) + sum(`helper2`.`newToResolvedAndObsoleteCount`))) AS `newCount`,(sum(`helper2`.`ackCount`) - sum(`helper2`.`ackToResolvedAndObsoleteCount`)) AS `ackCount`,(select count(0) from `ocum_report_birt`.`basicevents` where (cast(`basicevents`.`resolvedTimestamp` as date) = `helper1`.`lastUpdatedTime`)) AS `resolvedCount`,(select count(0) from `ocum_report_birt`.`basicevents` where (cast(`basicevents`.`obsoleteTimestamp` as date) = `helper1`.`lastUpdatedTime`)) AS `obsoleteCount` from (`ocum_report_birt`.`eventstatecharthelper` `helper1` join `ocum_report_birt`.`eventstatecharthelper` `helper2` on((`helper2`.`lastUpdatedTime` <= `helper1`.`lastUpdatedTime`))) group by `helper1`.`lastUpdatedTime`
Possibly Referenced Tables/Views: