using toSql()

Method Illuminate\Database\Eloquent\Collection::toSql does not exist

 $range = ProductCategory::whereIn('id', $categoryIds)
                        ->translatedIn('en')->get();      

 dd($range->toSql());

I want to see the result of the sql but unable to do so. Even after I delete the ->get(); still does not works.

Any clue why?

Level 70

try this-

ProductCategory::whereIn('id', $categoryIds)
    ->translatedIn('en')->toSql();

1 like

Level 73

The range is a collection of the result returned from the query. You need to do the toSqlon the query.

So try

dd( ProductCategory::whereIn('id', $categoryIds)
                        ->translatedIn('en')->toSql());

2 likes

Level 1

This is old, but you forgot to add query(), so it will be

$range = ProductCategory::query()->whereIn('id', $categoryIds) ->translatedIn('en') ;

dd($range->toSql());

Level 122

@kingsconsult 4 years ago..... and query() is entirely optional

1 like

Level 50

@Snapey Also instead of:

dd(...->translatedIn('en')->toSql());

You can chain the dd() call:

...->translatedIn('en')->dd();

Don't know if this is common knowledge, I just recently found out myself.

Please or to participate in this conversation.