| Actor | Fragment | Worker | State |
|---|---|---|---|
| 54068 | 2453 | 3 | running |
| 54069 | 2453 | 3 | running |
| 54070 | 2454 | 3 | running |
| 54071 | 2454 | 3 | running |
| 54072 | 2456 | 3 | running |
| 54073 | 2456 | 3 | running |
| 54094 | 2459 | 3 | running |
| 54095 | 2460 | 3 | running |
| 54096 | 2462 | 3 | running |
| 54097 | 2462 | 3 | running |
| 54098 | 2463 | 3 | running |
| 54099 | 2463 | 3 | running |
CREATE MATERIALIZED VIEW authz.user_accessible_parties_mv AS
SELECT
tm.user_id,
etm.entity_id AS party_id,
MAX(GREATEST(tm.updated_at, etm.updated_at)) AS updated_at
FROM olap.teams_memberships_dm AS tm
JOIN olap.entity_to_teams_dm AS etm
ON tm.team_id = etm.team_id AND etm.entity_type = 'PARTY'
JOIN party.customer_relationships AS cr
ON etm.entity_id = cr.party_id
AND cr.type = 'CUSTOMER'
AND cr.status IN ('ACTIVE', 'DRAFT', 'PENDING')
AND cr.disabled_at IS NULL
JOIN party.parties AS p
ON p.id = cr.party_id AND p.disabled_at IS NULL
WHERE
tm.disabled_at IS NULL
AND NOT tm.temporary IS TRUE
AND etm.disabled_at IS NULL
AND etm.effective_start_date <= CURRENT_TIMESTAMP
AND (
etm.effective_end_date IS NULL OR etm.effective_end_date > CURRENT_TIMESTAMP
)
GROUP BY
tm.user_id,
etm.entity_id