PSI - 13 Numerator Query

gistfile1.txt

# PSI - 13 Numerator Query
GET dexur_flagging_test/_search
 { "query": {
    "bool": {
      "filter": [
        { "term": { "network_id_id": 5003 }},
        { "term": { "organization_id_id": 71001181 }},
        { "term": { "object_id_id": 87 }},
        {
          "nested": {
            "path": "sections",
            "query": {
              "bool": {
                "must": [
                  { "term": { "sections.section_id_id": 752 }},
                  { "term": { "sections.string_frame_2": "Inpatient" }}
                ]
              }
            }
          }
        },
        {
          "nested": {
            "path": "sections",
            "query": {
              "bool": {
                "must": [
                  { "term": { "sections.section_id_id": 2378 }},
                  { "term": { "sections.text_frame_262.keyword": "Raltin" }}
                ]
              }
            }
          }
        },
        {
                    "nested": {
                      "path": "associations.sections",
                      "query": {
                        "bool": {
                          "must": [
                            { "term": { "associations.sections.section_id_id": 1297 }},
                            {"terms": {
                              "associations.sections.text_frame_1.keyword": ["A411", "A227", "A021", "A4189", "A414", "A408", "A400", "A4101", "A327", "A401", "A4181", "A412", "A413", "A403", "T8112XA", "R6520", "R6521", "A419", "A4153", "A427", "B377", "T8144XA", "A5486", "A4102", "A4152", "A4151", "A267", "A4154", "A4150", "A409", "A4159"]
                            }},
                            { "term": { "associations.sections.string_frame_2": "secondary diagnosis" }}
                          ]
                        }
                      }
                    }
                  }
        ]
    }}


}