query-functions.md

Query functions

Aranguent supports most query functions available in vanilla Laravel. You'll find a full list of compatible functions here. In addition the following functions have been added:

searchView && rawSearchView

These functions allow you to search ArangoViews. They are explained here in more detail.

fromOptions($options)

fromOptions allows you to set options for the initial 'from' statement of the query builder. In AQL these are the 'FOR' options as described here.

This enables you to indexHint inverted indexes which can then be used by filters such as where and having functions.

Example:

\DB::table('houses')
        ->fromOptions([
            'indexHint' => 'InvIdx',
            'forceIndexHint' => true
        ])
        ->where('en.description', 'LIKE', '%Westeros%')
        ->get();