query.json

{
  "query": {
    "terms": {
      "profile": [
        "advisory",
        "alert",
        "story",
        "story-enriched"
      ]
    },
    "bool": {
      "must": [
        {
          "range": {
            "firstcreated": {
              "gte": "01/07/2018",
              "lte": "07/07/2018",
              "format": "dd/MM/yyyy"
            }
          }
        }
      ],
      "nested": {
        "path": "object",
        "query": {
          "bool": {
            "must_not": {
              "match": {
                "object.code": "pacontent:private"
              }
            }
          }
        }
      }
    }
  },
  "sort": {
    "firstcreated": {
      "order": "desc"
    }
  }
}