Revisions to Python elasticsearch return only entries that have a certain field

validate json

Source Link

edit approved Mar 31, 2017 at 19:27

15.1k
12
63
92

You can try with this filtered query

{
  "size": 1000"query"1000,
  "query": {
    "filtered": {
      "filter": {
        "bool": {
          "must": {
            "exists": {
              "field": "fields.EventData.PGID"
            },
            {
              "term": {
                "run_id": "Run001"
              }
            }
          }
        }
      }
    }
  }
}

I think you can also add the sorting to the query

You can try with this filtered query

{
  "size": 1000"query": {
    "filtered": {
      "filter": {
        "bool": {
          "must": {
            "exists": {
              "field": "fields.EventData.PGID"
            },
            {
              "term": {
                "run_id": "Run001"
              }
            }
          }
        }
      }
    }
  }
}

I think you can also add the sorting to the query

You can try with this filtered query

{
  "size": 1000,
  "query": {
    "filtered": {
      "filter": {
        "bool": {
          "must": {
            "exists": {
              "field": "fields.EventData.PGID"
            },
            "term": {
              "run_id": "Run001"
            }
          }
        }
      }
    }
  }
}

I think you can also add the sorting to the query

previous json was invalid

Source Link

edit approved Mar 31, 2017 at 16:30

kgf3JfUtW

15.1k
12
63
92

youYou can try with this filtered query :

q = {
  "size":1000
  "query"1000"query": {
    "filtered": {
      "filter": {
        "bool": {
          "must": {
            "exists": {
              "exists""field": {"fields.EventData.PGID"
            },
    "field": "fields.EventData.PGID"       {
              },
"term": {
             {"term" : { "run_id" : "Run001"}},
              }
            }
          }
        }
      }
    }
  }
}

I think you can also add the sorting to the query

you can try with this filtered query :

q = {
  "size":1000
  "query": {
    "filtered": {
      "filter": {
        "bool": {
          "must": 
            {
              "exists": {
                "field": "fields.EventData.PGID"
              },
              {"term" : { "run_id" : "Run001"}},
             
            }
          
        }
      }
    }
  }
}

I think you can also add the sorting to the query

You can try with this filtered query

{
  "size": 1000"query": {
    "filtered": {
      "filter": {
        "bool": {
          "must": {
            "exists": {
              "field": "fields.EventData.PGID"
            },
            {
              "term": {
                "run_id": "Run001"
              }
            }
          }
        }
      }
    }
  }
}

I think you can also add the sorting to the query

Source Link

answered Mar 31, 2017 at 15:37

ML_TN

729
6
16

you can try with this filtered query :

q = {
  "size":1000
  "query": {
    "filtered": {
      "filter": {
        "bool": {
          "must": 
            {
              "exists": {
                "field": "fields.EventData.PGID"
              },
              {"term" : { "run_id" : "Run001"}},
             
            }
          
        }
      }
    }
  }
}

I think you can also add the sorting to the query

Collectives™ on Stack Overflow

Return to Answer