gistfile1.txt

{
  "app_id": "090187aa-47ee-35e7-62a1-20e2f6fa5d8c",
  "search_id": "40aacc98-3d37-4ae9-a900-0d98410721cb",
  "data_source_query": [
    {
      "dsid": 1,
      "query": {
        "or": [
          {
            "field": "all_sender_recipient",
            "operation": "SUBSTR",
            "value": "alanaegaymon",
            "and": [
              {
                "field": "Body",
                "operation": "SUBSTR",
                "value": "attachment"
              },
              {
                "field": "Body",
                "operation": "SUBSTR",
                "value": "the"
              },
              {
                "field": "Date",
                "operation": "\u003e=",
                "value": "1970-02-26T00:00:00Z"
              },
              {
                "field": "Date",
                "operation": "\u003c=",
                "value": "2015-05-07T00:00:00Z"
              }
            ]
          }
        ]
      },
      "functions": [
        {
          "field": "childcount",
          "operation": "SUM"
        },
        {
          "field": "Date",
          "operation": "MIN"
        },
        {
          "field": "Date",
          "operation": "MAX"
        }
      ]
    }
  ]
}