Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

What campaigns are generating completed events?

select rel_campaign.name, count(*)
from rel_eng_completed_events
join rel_eng_workflow
  on rel_eng_completed_events.wf_id = rel_eng_workflow.id
join rel_campaign
  on rel_eng_workflow.campaign_id = rel_campaign.primary_key
group by rel_campaign.name
order by rel_campaign.name;