View ocum_report_birt.volumerelationshiphistorychartcountview | Generated by SchemaSpy |
View Definition:
select date_format(`volumerelationshiphistoryview`.`startTime`,'%Y-%m-%d') AS `triggerdDate`,(case when (`volumerelationshiphistoryview`.`operationResult` = 'success') then 1 else 0 end) AS `successCount`,(case when (`volumerelationshiphistoryview`.`operationResult` <> 'success') then 1 else 0 end) AS `failCount` from `ocum_report_birt`.`volumerelationshiphistoryview`
Possibly Referenced Tables/Views: