jkdeveyra

select a.* from (
	select ac.contact_id, a.* from civicrm_activity a
	join civicrm_activity_contact ac on ac.activity_id=a.id and ac.record_type_id = 3
	join civicrm_option_value v on v.value=a.activity_type_id and v.option_group_id = 2 and v.name like '%225 Download Packet%'
	join civicrm_contact c on c.id = ac.contact_id
	where c.is_deleted = 0
) as a
LEFT JOIN
(
    select ac.contact_id from civicrm_activity a

jkdeveyra

Feature: Display Headlines

  # Related tickets: HAT-189
  Scenario Outline: Show list of categories in headline
    Given user is logged in
    * all campaigns are unapproved
    * approved campaign exists with details:
      | Title      | Campaign 1 |
      | Start Date | 01/01/2015 |
      | End Date   | 12/31/2015 |

jkdeveyra

Feature: Search campaigns

  Background:
    Given user is logged in
    * all campaigns are removed
    * campaigns exists:
      | Name                  | Enabled |
      | Presidential Campaign | true    |
      | Campaign 1            | true    |
      | Campaign Summer       | false   |

jkdeveyra

Feature: Search campaigns

  Background:
    Given user is logged in
    * all campaigns are removed
    * campaigns exists:
      | Title                 | Approved |
      | Presidential Campaign | true     |
      | Campaign 1            | true     |
      | Campaign Summer       | false    |

jkdeveyra

/**
 * Campaign Templates collection.
 */
CampaignTemplates = new Meteor.Collection('campaign_templates');

var CategorySchema = new SimpleSchema({
    "name": { type: String },
    "code": { type: String },
    "type": { type: String },
    "values": { type: [String] }