Level 102
Whats the use case ? Sounds like it is just going to be really slow
1 like
Nov 21, 2022
7
Level 8
Can I use get and paginate together?
I have a case where I want to get the the data then extract information from it, but also paginate it.
In my case I want to pluck the id column from the query data
Instead of just doing 2 queries (for the get and pagination, though not big deal)
Level 8
@Sinnbeck I want to pluck the ids column, and use the id array in another whereIn query
Level 102
@Ligonsker So the pagination is on the second query?
$ids = User::where('foo', $bar)->pluck('id');
$posts = Post::whereIn('user_id', $ids)->paginate(20);
1 like
Level 104
@Ligonsker a whereIn subquery can solve this; e.g.
User::whereIn('id', function($builder) {
$builder->select('user_id')->from('posts');
})->paginate();
Now, you have only one query
1 like
Level 8
@tykus Oh I need to try it out, looks nice
Level 8
Level 102
@Ligonsker I belive it would yes. It's just inside a single query
1 like
Please or to participate in this conversation.