Eager loading doesn't work about laravel-translatable HOT 6 CLOSED

I should mention that the model works in normal use for example in the edit or index views that i have. Its only eager loading that's broken.

from laravel-translatable.

The translations are not eager loaded out of the box. You have to add them in the with() method when you need them, as you would do with any other eloquent model.

In your case, I guess it would be something like this:

$game = Game::with('players', 'rounds', 'rounds.questions', 'rounds.questions.translations')->find($game->id);

from laravel-translatable.

Thanks for the quick answer, however that fetches all translations. Is there any way i can choose to get only a specific language?

I realize i can loop over the result and "fix" that but i don't want to pull more data from the database than necessary.

from laravel-translatable.

Have a look at the laravel documentation to see how you can limit eager loaded data. Search for "Eager Load Constraints" in the eloquent page.

from laravel-translatable.

Closing as not relevant to the repository.

from laravel-translatable.

@dimsav Hi, thanks for this module :D but, i get problems with this too. Using with, using constraints, everything.

category controller:

        $category = \App\Category::find(1)->with(['products','products.translations'=>function($query){$query->select(['product_id', 'name'])->where('locale','=','nl');},'categoryFeatures'])->firstOrFail();
        return view('category', ['category'=>$category,'ancestors'=>$ancestors]);

category view:

            @if(! empty($category->products))
                @forelse ($category->products as $product)
                    <div class="col-xs-12 col-sm-12 col-md-12 col-lg-12 categorybox">
                        <a href="{{$product->product_url}}">
                            <div class="category">
                                @if( ! empty($product->productGallery[0]["thumb_link"]))
                                    <img src="{{$product->productGallery[0]["thumb_link"]}}" />
                                @endif
                                {{ var_dump($product->translations) }} ({{trans('routing.product')}} {{$product->id}})
                            </div>
                        </a>
                    </div>
                @empty
                @endforelse
            @endif

this way i get over 300 queries, one for each translation of every product. When i remove the translation from the view it has only 10 queries on my whole page. so it seems like it's not passing the translations on the forst query?

Bart

from laravel-translatable.