Laravel-mongodb: Text Search in Mongo

[dhananjaygoel]

How can I do text search in mongo using this library?

[alexandre-butynski]

You just have to use the whereRaw method. It can be better if you encapsulate this in a query scope.

class User extends Moloquent {

    public function scopeWhereFullText($query, $search)
    {
        return $query->whereRaw(array('$text' => array('$search' => $search)));
    }

}

User::whereFullText('jaygoel')->get();

[amahrt]

This should be in the readme! :-) +1

[orangeShadow]

And how ordered that by score like in js query?
db.products.find({$text:{$search:"SomeText"}},{score:{$meta:'textScore'}}).sort({score:{$meta:'textScore'}})

[alexandre-butynski]

I think that you can only do this by using PHP Driver base methods. It can be something like that :

User::raw(function ($collection) use ($search) {
    return $collection->find(
        [
            '$text' => ['$search' => $search]
        ],
        [
            'score' => ['$meta' => 'textScore']
        ]
    )->sort(
        [
            'score' => ['$meta' => 'textScore']
        ]
    )->limit(6);
});

[orangeShadow]

I write that code

public function scopeWhereFullText($query, $search)
{
    $query->getQuery()->projections = ['score'=>['$meta'=>'textScore']];

    return $query->whereRaw(['$text' => ['$search' => $search]]);

}

and in result

$products = Product::whereFullText($request->get('q',''))
                    ->orderBy('score',['$meta'=>'textScore'])->get();

$max = $products->max('score');
$min = $products->min('score');

$products = $products->filter(function($item) use($max,$min){
    return $item->score > ($max+$min)/2;
});

But this method broke pagination :(

[alexandre-butynski]

Sometimes some ORM methods are broken when you use low level methods. I didn't experience your use case but you can try to make a custom paginator like that :

protected function customPaginator($query, $countParam, $perPage)
{
    $paginator = $query->getQuery()->getConnection()->getPaginator();

    $total = $query->count($countParam);

    $page = $paginator->getCurrentPage($total);

    $items = $query->forPage($page, $perPage)->get()->all();

    return $paginator->make($items, $total, $perPage);
}

Or to do something else custom and more low level than the standard paginator method. Can't be more helpful today, sorry !

[mateusvtt]

An alternative for custom pagination using textScore:

//App\Models\User

public function scopeWhereFullText($query, $search, $page = 1, $limit = 10)
    {
        $query->getQuery()->projections = ['score'=>['$meta'=>'textScore']];

        $query->orderBy('score',['$meta'=>'textScore']);

        $query->skip(($page - 1)*$limit);

        $query->take($limit);

        return $query->whereRaw(['$text' => ['$search' => $search]]);
    }

Usage:
User::whereFullText('searchable',1,10)->get();

[balap777]

hello @mateusvtt i am using your function for mongodb it works but when i use another orberby after $query->orderBy('score',['$meta'=>'textScore']) the second orberby not been used or been neglected for ordering the data your help will greatly appreciated

[mateusvtt]

Hi @balap777 I've tried to reproduce your issue adding a extra field to sort.

$query->orderBy('score',['$meta'=>'textScore'])->orderBy('_id', 'asc');

It works here, but keep in mind that the second orderBy acts as a tie-breaking criterion. I.e. the documents with the highest score will continue at the top, only those with similar scores will be resorted.

[ederson-cinnamon]

Hi good day I am getting _MongoDBDriverExceptionCommandException: text index required for $text query in file_

--model

`

namespace App;

use JenssegersMongodbEloquentModel;
use JenssegersMongodbEloquentSoftDeletes;

class Listing extends Model
{

public function scopeWhereFullText($query, $search, $page = 1, $limit = 10)
{

    $query->getQuery()->projections = ['score'=>['$meta'=>'textScore']];

    $query->orderBy('score',['$meta'=>'textScore']);

    $query->skip(($page - 1)*$limit);

    $query->take($limit);

    return $query->whereRaw(array('$text' => array('$search' => $search)));
}`

--controller

public function search(){
return Listing::whereFullText('searchable',1,10)->get();
}

I already created an index

[Smolevich]

@ederson-cinnamon i don't see field name in search query

[ederson-cinnamon]

@Smolevich Hi what do you mean? I'm not sure how to properly declare it. can you give example?

[ederson-cinnamon]

got it, adding index something like this solve my issue.

I inserted it using cloud.mongodb.com.

[Sahandi81]

wut is $text and $search variable?

i get
text index required for $text query",

[jcaillot]

@Sahandi81

Those operators require an indexed field. Check Mongo doc here:
https://docs.mongodb.com/manual/reference/operator/query/text/

[Sahandi81]

@jcaillot

Thanks, you Right.

but how i can add this to db fields? i dont find any way to do that ...

for insert new record i use
Product::create([ 'title' => "randomString" ])

[jcaillot]

One can create a text index during migration using:

use Illuminate\Database\Migrations\Migration;
//use Illuminate\Database\Schema\Blueprint; <<-- note the replacement
use Illuminate\Support\Facades\Schema;
use Jenssegers\Mongodb\Schema\Blueprint;


class IndexedTexts extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('indexed_texts', function (Blueprint $collection) {
            $collection->id();
            $collection->string('any_text');

            $collection->index(
                ['any_text' => 'text'], // <-- this does the trick
                null,
                null,
                [
                    // text indexes only support simple binary comparison and do not support collation.
                    'collation' => ['locale' => "simple"],
                ]
            );
        });
    }

see https://github.com/jenssegers/laravel-mongodb/blob/6aa6ad12b3b52eeab1d090f282c14123ffad1dc9/src/Schema/Blueprint.php#L45