| Actor | Fragment | Worker | State |
|---|---|---|---|
| 745886 | 63310 | 51 | running |
| 745887 | 63310 | 51 | running |
| 745892 | 63311 | 51 | running |
| 745893 | 63311 | 51 | running |
CREATE MATERIALIZED VIEW alinma_bff.party_task_counts_mv AS
SELECT
party_id,
CAST(COUNT(*) FILTER(WHERE
status IN ('TO_DO', 'IN_PROGRESS')) AS INT) AS active_count,
CAST(COUNT(*) FILTER(WHERE
status IN ('TO_DO', 'IN_PROGRESS') AND priority = 'HIGH') AS INT) AS high_priority_count,
CAST(COUNT(*) FILTER(WHERE
status IN ('TO_DO', 'IN_PROGRESS') AND is_overdue) AS INT) AS overdue_count
FROM alinma_bff.party_task_unique_mv AS party_task_unique_mv_next
GROUP BY
party_id