GraphQL Search Query Tutorial¶

query getWookiees {
 wookiee_search
  {
    max_score
    hits {
      score
      wookiee {
        id
        name
        rdfs_label {value lang}
      }
    }
  }
}

query allFilms {
   film_search(
     query: {
       match_all: {boost: 5.0}
     }
     size:1000
   )
   {
     hits {
       score
       film {
         id
         name
       }
     }
   }
 }

{
    character_search
    (
        aggs: [
            {
                name: "avg01"
                value: {
                    avg: {
                        field: "height"
                    }
                }
            }
            {
                name: "avg01missing"
                value: {
                    avg: {
                        field: "height"
                        missing: 50
                    }
                }
            }
        ]
    )
    {
        aggregations
    }
}

{
  character_search
  (
    aggs: [
      {
        name: "homeworld nested"
        value: {
          nested: {
            path: "homeworld"
          }
          aggs: {
            name: "homeworld cardinality"
            value: {
              cardinality: {
                field: "homeworld.id"
                precision_threshold: 10
              }
            }
          }
        }
      }
      {
        name: "gender cardinality"
        value: {
          cardinality: {
            field: "gender"
            missing: "N/A"
          }
        }
      }
    ]
  )
  {
    aggregations
  }
}

{
    character_search
    (
        aggs: [
            {
                name: "height max"
                value: {
                    max: {
                        field: "height"
                    }
                }
            }
            {
                name: "height max missing"
                value: {
                    max: {
                        field: "height"
                        missing: 1000
                    }
                }
            }
            {
                name: "height max script"
                value: {
                    max: {
                        field: "height"
                        script: {
                            lang: "painless"
                            source: "if (_value != null) return _value * params.multiplier; return -1;"
                            params: {multiplier: 3}
                        }
                    }
                }
            }
        ]
    )
    {
        aggregations
    }
}

{
    character_search
    (
        query:{
            term: {
                type: {
                    value: "https://swapi.co/vocabulary/Human"
                }
            }
        }
        aggs: [
            {
                name: "height min"
                value: {
                    min: {
                        field: "height"
                    }
                }
            }
            {
                name: "height min missing"
                value: {
                    min: {
                        field: "height"
                        missing: 10
                    }
                }
            }
            {
                name: "height min script"
                value: {
                    min: {
                        field: "height"
                        script: {
                            lang: "painless"
                            source: "if (_value != null) return _value * params.multiplier; return 10000;"
                            params: {multiplier: 3}
                        }
                    }
                }
            }
        ]
    )
    {
        aggregations
    }
}

{
    species_search
    (
        aggs: [
            {
                name: "averageHeight percentile ranks"
                value: {
                    percentile_ranks: {
                        field: "averageHeight"
                        values: [70, 100, 200]
                    }
                }
            }
        ]
    )
    {
        aggregations
    }
}

{
    character_search
    (
        aggs: [
            {
                name: "mass percentile ranks"
                value: {
                    percentiles: {
                        field: "mass"
                    }
                }
            }
            {
                name: "mass percentile ranks missing"
                value: {
                    percentiles: {
                        field: "mass"
                        missing: 300
                    }
                }
            }
            {
                name: "mass percentile ranks not keyed"
                value: {
                    percentiles: {
                        field: "mass"
                        keyed: false
                    }
                }
            }
            {
                name: "mass percentile ranks hdr"
                value: {
                    percentiles: {
                        field: "mass"
                        hdr: {
                            number_of_significant_value_digits: 1 # returned value accuracy is lowered by this , so 99.9 percentile gets higher than the max mass value
                        }
                        percents: [ 95, 99, 99.9 ]
                    }
                }
            }
            {
                name: "mass percentile ranks compression"
                value: {
                    percentiles: {
                        field: "mass"
                        tdigest: {
                            compression: 101
                        }
                    }
                }
            }
        ]
    )
    {
        aggregations
    }
}

{
    character_search
    (
        aggs: [
            {
                name: "character height stats"
                value: {
                    stats: {
                        field: "height"
                    }
                }
            }
            {
                name: "character height stats missing"
                value: {
                    stats: {
                        field: "height"
                        missing: 100
                    }
                }
            }
            {
                name: "character mass stats"
                value: {
                    stats: {
                        field: "mass"
                    }
                }
            }
        ]
    )
    {
        aggregations
    }
}

{
    character_search
    (
        aggs: [
            {
                name: "character gender string_stats"
                value: {
                    string_stats: {
                        field: "gender"
                    }
                }
            }
            {
                name: "character gender string_stats missing"
                value: {
                    string_stats: {
                        field: "gender"
                        missing: "droiddddddddddddddddd"
                    }
                }
            }
            {
                name: "character gender string_stats script"
                value: {
                    string_stats: {
                        script: {
                            source: "if (doc.gender.size() != 0) doc.gender.value"
                        }
                    }
                }
            }
            {
                name: "character gender string_stats with distribution"
                value: {
                    string_stats: {
                        field: "gender"
                        show_distribution: true
                    }
                }
            }
        ]
    )
    {
        aggregations
    }
}

{
    character_search
    (
        aggs: [
            {
                name: "character height sum"
                value: {
                    sum: {
                        field: "height"
                        missing: 100
                    }
                }
            }
            {
                name: "character mass sum"
                value: {
                    sum: {
                        field: "mass"
                    }
                }
            }
        ]
    )
    {
        aggregations
    }
}

{
    character_search
    (
        query: {
            terms: {
                eyeColor: ["blue", "gray", "yellow", "green"]
                }
        }
        aggs: [
            {
                name: "character's height for top mass"
                value: {
                    top_metrics: {
                        metrics: [
                            {field: "height"}
                            {field: "mass"}
                        ]
                        sort: {mass: desc}
                    }
                }
            }
        ]
        size: 2
    )
    {
        aggregations
        hits{
            score
            character{
                id
                name
                height
                mass
                eyeColor
            }
        }
    }
}

{
    planet_search
    (
        aggs: [
            {
                name: "planet"
                value: {
                    terms:{
                        field: "id"
                    }
                    aggs:{
                        name: "residents stats"
                        value: {
                            nested: {
                                path: "resident"
                            }
                            aggs:{
                                name: "residentStats"
                                value: {
                                    value_count: {
                                        field: "resident.id"
                                    }
                                }
                            }
                        }
                    }
                }
            }
        ]
    )
    {
        aggregations
    }
}

{
    film_search
    (
        aggs: [
            {
                name: "film"
                value: {
                    terms:{
                        field: "id"
                    }
                    aggs:[
                        {
                            name: "boxOffice wighted by cost"
                            value: {
                                weighted_avg: {
                                    value: {
                                        field: "boxOffice"
                                    }
                                    weight: {
                                        field: "cost"
                                    }
                                }
                            }
                        }
                        {
                            name: "boxOffice wighted by cost with missing"
                            value: {
                                weighted_avg: {
                                    value: {
                                        field: "boxOffice"
                                        missing: "333"
                                    }
                                    weight: {
                                        field: "cost"
                                        missing: "1"
                                    }
                                    value_type: "double"
                                }
                            }
                        }
                    ]
                }
            }
        ]
    )
    {
        aggregations
    }
}

{
    awardRecognition_search
    (
        aggs: {
            name: "awardDate_aggs"
            value: {
                date_range: {
                    field: "awardDate"
                    format: "yyyy-MM-dd"
                    ranges: [
                        {to: "now-30y/y"}
                        {from: "now-30y/y", to:"now-20y/y"}
                        {from: "now-20y/y", to:"now-10y/y"}
                        {from: "now-10y/y"}
                    ]
                }
            }
        }
    )
    {
        aggregations
    }
}

{
    character_search
    (
        aggs: {
            name: "filter"
            value: {
                filter: {
                    term: {height: {value: "183.0"}}
                }
                aggs:[
                    {
                        name: "avg_mass"
                        value: {avg: {field: "mass"}}
                    }
                ]
            }
        }
    )
    {
        aggregations
    }
}

{
    character_search
    (
        aggs: {
            name: "missing_mass"
            value: {
                missing: { field: "mass"}
                aggs: {
                    name: "avg_height"
                    value: {avg: {field: "height"}}
                }
            }
        }
    )
    {
        aggregations
    }
}

{
    film_search
    (
        query: {
          terms: {id: ["https://swapi.co/resource/film/4"]}
        }
        aggs: {
            name: "location_min_type"
            value: {
                nested: {
                    path: "location"
                }
                aggs: {
                  name: "min_type"
                  value: {
                    string_stats: {field: "location.type"}
                  }
                }
              }
            }
      size: 100
    )
    {
        aggregations
        hits{
          film{
            id
            name
            location
            {
              id
              type
            }
          }
        }
    }
}

{
    character_search
    (
        aggs: {
            name: "height_ranges"
            value: {
                range: {
                    field: "height"
                    ranges: [
                      {to: 170}
                      {from: 170, to:190}
                      {from: 190, to:200}
                      {from: 200}
                    ]
                }
            }
        }
    )
    {
        aggregations
    }
}

{
  character_search
  (
    aggs: {
      name: "terms1"
      value: {
        nested: {
          path: "homeworld"
        }
        aggs: {
          name: "terms1"
          value: {
            terms: {
              field: "homeworld.id"
              size: 5
              show_term_doc_count_error: true
            }
          }
        }
      }
    }
  )
  {
  aggregations
  }
}

{
    character_search
    (
        aggs: {
            name: "terms2"
            value: {
                terms: {
                    field: "height"
                    order: { _count: "desc" }
                    size: 16
                    shard_size: 5
                }
            }
        }
        size: 100
    )
    {
        aggregations
    }
}

{character_search
(
    aggs: {
        name: "terms2"
        value: {
            terms: {
                field: "gender"
                size: 15
                exclude: "fem.*"
            }
        }
    }
    size: 100
)
{
    aggregations
}
}

{
    root_search
    (
        aggs: {
            name: "rootTerms"
            value: {
                terms: {
                    field: "type"
                    size: 19
                    show_term_doc_count_error: true
                }
                aggs: [
                    {
                        name: "height_stats"
                        value: {stats: {field: "height"}}
                    }
                    {
                        name: "mass_stats"
                        value: {stats: {field: "mass"}}
                    }
                    {
                        name: "diameter_max"
                        value: {max: {field: "diameter"}}
                    }
                    {
                        name: "length_max"
                        value: {max: {field: "length"}}
                    }
                ]
            }
        }
    )
    {
        aggregations
    }
}

{
    planet_search
    (
        aggs: [
            {
                name: "planet"
                value: {
                    terms:{
                        field: "id"
                        size: 10
                    }
                    aggs:{
                        name: "residents"
                        value: {
                            nested: {
                                path: "resident"
                            }
                            aggs:[
                                {
                                    name: "residentAvgHeight"
                                    value: {
                                        avg: {
                                            field: "resident.height"
                                        }
                                    }
                                }
                                {
                                    name: "residentMinHeight"
                                    value: {
                                        min: {
                                            field: "resident.height"
                                        }
                                    }
                                }
                                {
                                    name: "residentMaxHeight"
                                    value: {
                                        max: {
                                            field: "resident.height"
                                        }
                                    }
                                }
                                {
                                    name: "residentPercentilesHeight"
                                    value: {
                                        percentiles: {
                                            field: "resident.height"
                                        }
                                    }
                                }
                            ]
                        }
                    }
                }
            }
        ]
    )
    {
        aggregations
    }
}

{
    character_search
    (
        aggs: {
            name: "film"
            value: {
                nested: {
                    path: "film"
                }
                aggs: {
                    name: "film_terms"
                    value: {
                        terms: {
                            field: "film.id"
                        }
                        aggs: {
                            name: "reverse_nested"
                            value: {
                                reverse_nested: {}
                                aggs: {
                                    name: "gender"
                                    value: {
                                        terms: {
                                            field: "gender"
                                            missing: "probably_droid"
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
    )
    {
        aggregations
    }
}

query character_aggregations {
  character_search(
    aggs: [{
      name: "heights",
      value: {
        terms: {
          field: "height"
        }
      }
    }, {
      name: "max-height",
      value: {
        max: {
          field: "height"
        }
      }
    }, {
      name:"min-height",
      value: {
        min: {
          field: "height"
        }
      }
    }]
  ) {
    max_score
    aggregations
  }
}

query character_aggregations {
  character_search(
    query: {
      match: {
        eyeColor: {
          query: "blue"
        }
      }
    }
    from: 5
    size: 5
    sort: {
      height: {
        order: desc
              }
       }
    aggs: [{
      name: "heights",
      value: {
        terms: {
          field: "height"
        }
      }
    }, {
      name: "max-height",
      value: {
        max: {
          field: "height"
        }
      }
    }, {
      name:"min-height",
      value: {
        min: {
          field: "height"
        }
      }
    }]
  ) {
    max_score
    hits {
      score
      character {
        id
        name
      }
    }
    aggregations
  }
}