Elasticsearch To Eloquent Mapping

Glossary of common Elasticsearch queries and their Eloquent equivalents, providing a quick reference for developers coming from Elasticsearch to Laravel’s Eloquent.

---

Full Text Queries

Match query

• where($field,$value)

$products = Product::where('manufacturer.country', 'England')->take(10)->get();

{
    "index": "products",
    "body": {
        "query": {
            "match": {
                "manufacturer.country": "England"
            }
        },
        "_source": [
            "*"
        ]
    },
    "size": 10
}

DSL

Match phrase query

• wherePhrase($field,$value)

return Person::wherePhrase('description', 'loves espressos')->get();

{
    "index": "people",
    "body": {
        "query": {
            "match_phrase": {
                "description": "loves espressos"
            }
        },
        "_source": [
            "*"
        ]
    }
}

DSL

Match phrase prefix query

• wherePhrasePrefix($field,$value)

return Person::wherePhrasePrefix('description', 'loves es')->get();

{
    "index": "people",
    "body": {
        "query": {
            "match_phrase_prefix": {
                "description": "loves es"
            }
        },
        "_source": [
            "*"
        ]
    }
}

DSL

Term level queries

Term query

• whereExact($field,$value)

return Person::whereExact('name', 'John Smith')->get();

This will only return the documents where the name field is exactly ‘John Smith’. ‘john smith’ or ‘John’ will not be returned.

{
    "index": "people",
    "body": {
        "query": {
            "term": {
                "name.keyword": "John Smith"
            }
        },
        "_source": [
            "*"
        ]
    }
}

DSL

Terms query

• whereIn($field,$values)

$products = Product::whereIn('status', [1,5,11])->get();

{
    "index": "products",
    "body": {
        "query": {
            "terms": {
                "status": [
                    1,
                    5,
                    11
                ]
            }
        },
        "_source": [
            "*"
        ]
    }
}

DSL

Range query

• whereBetween($field,[$min,$max])

$products = Product::whereBetween('in_stock', [10, 100])->get();

Find all products with an in_stock value between 10 and 100 (including 10 and 100)

{
    "index": "products",
    "body": {
        "query": {
            "range": {
                "in_stock": {
                    "gte": 10,
                    "lte": 100
                }
            }
        },
        "_source": [
            "*"
        ]
    }
}

DSL

• where($field, ’>’, $value)

$products = Product::where('status','>=', 3)->take(10)->get();

{
    "index": "products",
    "body": {
        "query": {
            "range": {
                "status": {
                    "gte": 3
                }
            }
        },
        "_source": [
            "*"
        ]
    },
    "size": 10
}

DSL

Exists query

• whereNotNull($field)

$products = Product::whereNotIn('color', ['red','green'])->whereNotNull('color')->get();

{
    "index": "products",
    "body": {
        "query": {
            "bool": {
                "must": [
                    {
                        "bool": {
                            "must_not": {
                                "terms": {
                                    "color": [
                                        "red",
                                        "green"
                                    ]
                                }
                            }
                        }
                    },
                    {
                        "exists": {
                            "field": "color"
                        }
                    }
                ]
            }
        },
        "_source": [
            "*"
        ]
    }
}

DSL

• whereNull($field)

$products = Product::whereNull('color')->get();

{
    "index": "products",
    "body": {
        "query": {
            "bool": {
                "must_not": [
                    {
                        "exists": {
                            "field": "color"
                        }
                    }
                ]
            }
        },
        "_source": [
            "*"
        ]
    }
}

DSL

Fuzzy query

• Not directly supported in v3.9/3.8, but can be implemented using search queries

Prefix query

• Not directly supported in v3.9/3.8, but can be implemented using search queries

Wildcard query

• Not directly supported in v3.9/3.8, but can be implemented using search queries

Multi-match query

Most Field

• Not directly supported in v3.9/3.8, but can be implemented using search queries

Cross Fields

• Not directly supported in v3.9/3.8, but can be implemented using search queries

Best Fields

• Not directly supported in v3.9/3.8, but can be implemented using search queries

Phrase

• Not directly supported in v3.9/3.8, but can be implemented using search queries

Phrase Prefix

• Not directly supported in v3.9/3.8, but can be implemented using search queries

Geo Queries

Geo-bounding box query

• filterGeoBox($field, $topLeft, $bottomRight)

// Define the top-left and bottom-right coordinates of the box
$topLeft = [-10, 10]; // [latitude, longitude]
$bottomRight = [10, -10]; // [latitude, longitude]

// Retrieve UserLogs where 'agent.geo' falls within the defined box
$logs = UserLog::where('status', 7)->filterGeoBox('agent.geo', $topLeft, $bottomRight)->get();

{
    "index": "user_logs",
    "body": {
        "query": {
            "bool": {
                "must": [
                    {
                        "match": {
                            "status": 7
                        }
                    }
                ],
                "filter": {
                    "geo_bounding_box": {
                        "agent.geo": {
                            "top_left": [
                                -10,
                                10
                            ],
                            "bottom_right": [
                                10,
                                -10
                            ]
                        }
                    }
                }
            }
        },
        "_source": [
            "*"
        ]
    }
}

DSL

Geo-distance query

• filterGeoDistance($field, $distance, $point)

// Specify the central point and radius
$point = [0, 0]; // [latitude, longitude]
$distance = '20km';

// Retrieve UserLogs where 'agent.geo' is within 20km of the specified point
$logs = UserLog::where('status', 7)->filterGeoPoint('agent.geo', $distance, $point)->get();

{
    "index": "user_logs",
    "body": {
        "query": {
            "bool": {
                "must": [
                    {
                        "match": {
                            "status": 7
                        }
                    }
                ],
                "filter": {
                    "geo_distance": {
                        "distance": "20km",
                        "agent.geo": {
                            "lat": 0,
                            "lon": 0
                        }
                    }
                }
            }
        },
        "_source": [
            "*"
        ]
    }
}

DSL