View ocum_report_birt.newtoresolvedandobsoleteevents | Generated by SchemaSpy |
View Definition:
select cast(coalesce(`basicevents`.`resolvedTimestamp`,`basicevents`.`obsoleteTimestamp`) as date) AS `lastUpdatedTime`,count(0) AS `eventsCount`,'NEW-RES/OBS' AS `state` from `ocum_report_birt`.`basicevents` where (isnull(`basicevents`.`acknowledgedTimestamp`) and ((`basicevents`.`resolvedTimestamp` is not null) or (isnull(`basicevents`.`resolvedTimestamp`) and (`basicevents`.`obsoleteTimestamp` is not null)))) group by `lastUpdatedTime`
Possibly Referenced Tables/Views: