dashboard should show dataquality feeds
summary.COMPLETED_COUNT AS COMPLETED_COUNT,
summary.ABANDONED_COUNT AS ABANDONED_COUNT,
summary.ALL_COUNT AS ALL_COUNT,
- summary.RUNNING_COUNT AS RUNNING_COUNT,
+ COALESCE(summary.RUNNING_COUNT,0) AS RUNNING_COUNT,
'FINISHED' AS RUN_STATUS
FROM LATEST_FINISHED_FEED_JOB_VW v
JOIN BATCH_JOB_EXECUTION e ON e.JOB_EXECUTION_ID = v.JOB_EXECUTION_ID
- JOIN BATCH_FEED_SUMMARY_COUNTS_VW summary ON summary.FEED_ID = v.FEED_ID
- WHERE summary.RUNNING_COUNT = 0
+ LEFT JOIN BATCH_FEED_SUMMARY_COUNTS_VW summary ON summary.FEED_ID = v.FEED_ID
]]>
</createView>
</changeSet>
