Pagination of results about laravel-searchy HOT 8 CLOSED

Allright, I read through the old issues and solved the pagination by doing this:

    $jobMatches = Searchy::search('jobs')
        ->fields('title', 'description')
        ->query($searchQuery)
        ->getQuery()
        ->having('relevance', '>', 10)
        ->skip($rowsToSkip)
        ->take($numPerPage)
        ->get();

Maybe someone with the same problem might find this helpful.

from laravel-searchy.

Searchy::qtn('title', 'name')
->query('d')
->getQuery()
->simplePaginate(2);

from laravel-searchy.

Great! Thanks. Leaving this one open for reference as it's been asked a few time 😄

from laravel-searchy.

I have many relations, so when searching I returned only ID, and after using 'standard' query with whereIn('id', ...)

I know it is slow, but I in this case pagination works, relations works, ... because I get standard Eloquent object

from laravel-searchy.

@ankhuve You can also use limit instead of take

from laravel-searchy.

@sml2h3 ... only simplePaginate works.. however, it would be wonderful if paginate method also works

from laravel-searchy.

i have the same issue

from laravel-searchy.

There are technical limitations that meant this can't easily be improved inside the library without blowing it out of it's original scope which is something that I don't want to do.

from laravel-searchy.