get all email campaigns

[AbhiAgarwal]

{
    "size": 0,
    "query": {
        "bool": {
            "must": [{
                "term": {
                    "data.CreatedBy": 5749563331706880
                }
            }, {
                "term": {
                    "data.IsSent": true
                }
            }]
        }
    },
    "aggs": {
        "distinct_subjects": {
            "cardinality": {
                "field": "data.Subject"
            }
        }
    }
}

[AbhiAgarwal]

not difficult to achive. let's not use this solution though... it's really hard to see the uniqueness and ES doesn't always do the best job at showing cardinality well. we should probably index it into another index & query that. adds more complexity to querying, but read/write easier in the future.