Laravel - filter by multiple relation values while keeping eloquent pagination

replied 9 years ago

Solution

I didn't test it, but how about something like this?

$tags = explode(',', Input::get('tags'));

foreach ($tags as $tag) {
    $tag = str_replace('-', ' ', $tag);

    $list = $list->whereHas('tags', function ($query) use ($tag) {
        $query->whereTag($tag);
    });
}

Last updated 9 years ago.

0

idiotstrike

replied 9 years ago

Thanks, that seems to be what I'm looking for. The only thing that troubles me is that this method generates a sub query for each of the tags, but I suppose there's no way around that.

0

kokokurak

replied 9 years ago

If you'd like to avoid subqueries, you can use a query like that:

SELECT `characters`.*, COUNT(`tags`.`id`) AS `tags_matches_count`
FROM `character_tag`
JOIN `characters`
  ON `characters`.`id` = `character_tag`.`character_id`
JOIN `tags`
  ON `tags`.`id` = `character_tag`.`tag_id`
WHERE `tags`.`tag` IN ('dogs', 'puppies')
GROUP BY `characters`.`id`
HAVING `tags_matches_count` = 2

You would need to pass a list of tags there (in place of dogs and puppies) and their number (in place of 2). I believe that would be more efficient.

0

idiotstrike

replied 9 years ago

I'd rather keep the Laravel syntax, it looks way nicer (besides, I don't think the performance gain would be anything to really bother with). If there are problems, I'll most likely just cache the entire model later on and build a paginator manually, as that seems to be the most efficient method.

Thanks a lot for contributing

0

kokokurak

replied 9 years ago

I always try to avoid raw queries too :) Plus, subqueries are a lot better than new queries.

0

Moderators