{
  "profile": true,
  "query": {
    "bool": {
        "must": {
          "match_all": {}
        },
        "filter": [
          {
              "terms": {
                "company_id": [
                    2613
                ]
              }
          },
          {
              "bool": {
                "should": [
                    {
                      "bool": {
                          "must_not": {
                            "nested": {
                                "path": "ajs_joins",
                                "query": {
                                  "exists": {
                                      "field": "ajs_joins.active"
                                  }
                                }
                            }
                          }
                      }
                    },
                    {
                      "nested": {
                          "path": "ajs_joins",
                          "query": {
                            "bool": {
                                "must": [
                                  {}
                                ]
                            }
                          }
                      }
                    }
                ]
              }
          }
        ]
    }
  },
  "post_filter": {
    "bool": {
        "must": [
          {
              "bool": {
                "should": [
                    {
                      "nested": {
                          "path": "ajs_joins",
                          "query": {
                            "term": {
                                "ajs_joins.responsible_user_id": "52404"
                            }
                          }
                      }
                    }
                ]
              }
          },
          {
              "nested": {
                "path": "fields_date",
                "query": {
                    "bool": {
                      "should": {
                          "bool": {
                            "must": [
                                {
                                  "term": {
                                      "fields_date.id": "training_date"
                                  }
                                },
                                {
                                  "range": {
                                      "fields_date.value": {
                                        "gte": "2022-06-01T00:00:00+03:00",
                                        "lte": "2022-06-01T23:59:59+03:00"
                                      }
                                  }
                                }
                            ]
                          }
                      },
                      "minimum_should_match": 1
                    }
                }
              }
          }
        ],
        "must_not": {
          "terms": {
              "status": [
                "archived",
                "depersonalized"
              ]
          }
        }
    }
  },
  "timeout": "30s",
  "sort": [
    {
        "created_at": {
          "order": "desc"
        }
    }
  ],
  "aggs": {
    "jobs": {
        "nested": {
          "path": "ajs_joins"
        },
        "aggs": {
          "filtered": {
              "filter": {
                "bool": {
                    "must": [
                      {},
                      {
                          "bool": {
                            "should": [
                                {
                                  "term": {
                                      "ajs_joins.job_private": false
                                  }
                                },
                                {
                                  "bool": {
                                      "must_not": {
                                        "exists": {
                                            "field": "ajs_joins.job_private"
                                        }
                                      }
                                  }
                                },
                                {
                                  "term": {
                                      "ajs_joins.jobs_users_user_id": 52404
                                  }
                                }
                            ]
                          }
                      }
                    ]
                }
              },
              "aggs": {
                "job_id": {
                    "terms": {
                      "field": "ajs_joins.job_id",
                      "size": 50
                    }
                }
              }
          }
        }
    },
    "ajs_joins": {
        "nested": {
          "path": "ajs_joins"
        },
        "aggs": {
          "total_scores": {
              "range": {
                "field": "ajs_joins.total_score",
                "ranges": [
                    {
                      "key": "0-25",
                      "from": 0,
                      "to": 26
                    },
                    {
                      "key": "25-50",
                      "from": 25,
                      "to": 51
                    },
                    {
                      "key": "50-75",
                      "from": 50,
                      "to": 76
                    },
                    {
                      "key": "75-100",
                      "from": 75,
                      "to": 101
                    }
                ]
              }
          },
          "stage_status": {
              "terms": {
                "script": "doc['ajs_joins.stage_status'].value",
                "size": 1000
              }
          },
          "declination_reasons": {
              "terms": {
                "field": "ajs_joins.declination_reason_id"
              }
          }
        }
    },
    "stage_types": {
        "nested": {
          "path": "ajs_joins"
        },
        "aggs": {
          "name": {
              "terms": {
                "field": "ajs_joins.stage_type_name",
                "size": 1000
              }
          }
        }
    },
    "tags": {
        "nested": {
          "path": "tags"
        },
        "aggs": {
          "id_and_name": {
              "terms": {
                "script": "doc['tags.id'].value + '|' + doc['tags.name'].value",
                "size": 1000
              }
          }
        }
    },
    "source_type_codes": {
        "terms": {
          "field": "source_type_code",
          "size": 100
        }
    },
    "source_ids": {
        "terms": {
          "field": "source_id",
          "size": 100,
          "missing": "0"
        }
    },
    "created_at": {
        "date_range": {
          "field": "created_at",
          "ranges": [
              {
                "from": "now-7d/d"
              },
              {
                "from": "now-1M/d"
              },
              {
                "from": "now-1y/d"
              }
          ]
        }
    },
    "statuses": {
        "terms": {
          "field": "status",
          "size": 100
        }
    },
    "agreement": {
        "terms": {
          "field": "agreement_confirmed",
          "size": 1000
        }
    },
    "cities": {
        "terms": {
          "field": "city",
          "size": 100
        }
    },
    "states": {
        "nested": {
          "path": "ajs_joins.states"
        },
        "aggs": {
          "states": {
              "terms": {
                "field": "ajs_joins.states.workflow_name"
              },
              "aggs": {
                "value": {
                    "terms": {
                      "field": "ajs_joins.states.state_id",
                      "size": 1000
                    }
                }
              }
          }
        }
    },
    "company_partner_id": {
        "terms": {
          "field": "company_partner_id",
          "size": 1000
        }
    },
    "responsible_users": {
        "aggs": {
          "responsible_user_id": {
              "terms": {
                "field": "ajs_joins.responsible_user_id",
                "size": 50
              }
          }
        },
        "nested": {
          "path": "ajs_joins"
        }
    },
    "total_experience": {
        "terms": {
          "field": "total_experience",
          "size": 100
        }
    },
    "language_levels_aggr": {
        "nested": {
          "path": "resumes"
        },
        "aggs": {
          "filtered": {
              "filter": {
                "bool": {
                    "must": {
                      "match": {
                          "resumes.actual": true
                      }
                    }
                }
              },
              "aggs": {
                "by_languages": {
                    "nested": {
                      "path": "resumes.languages"
                    },
                    "aggs": {
                      "languages": {
                          "terms": {
                            "field": "resumes.languages.id"
                          },
                          "aggs": {
                            "levels": {
                                "terms": {
                                  "field": "resumes.languages.level_id",
                                  "size": 1000
                                }
                            },
                            "no_level": {
                                "missing": {
                                  "field": "resumes.languages.level_id"
                                }
                            }
                          }
                      }
                    }
                }
              }
          }
        }
    },
    "citizenships": {
        "nested": {
          "path": "resumes"
        },
        "aggs": {
          "filtered": {
              "filter": {
                "bool": {
                    "must": {
                      "match": {
                          "resumes.actual": true
                      }
                    }
                }
              },
              "aggs": {
                "by_citizenship": {
                    "nested": {
                      "path": "resumes.citizenship"
                    },
                    "aggs": {
                      "citizenship": {
                          "terms": {
                            "field": "resumes.citizenship.name"
                          }
                      }
                    }
                }
              }
          }
        }
    },
    "dynamic_aggregation": {
        "nested": {
          "path": "fields"
        },
        "aggs": {
          "input_aggregation": {
              "terms": {
                "field": "fields.id",
                "size": 1000
              },
              "aggs": {
                "value": {
                    "terms": {
                      "field": "fields.value",
                      "size": 1000,
                      "missing": "other"
                    }
                }
              }
          }
        }
    }
  },
  "_source": false
}