not taking param into consideration?

[shez1983]

So I have a query such as this. and i have an api endpoint categories/id/products..

$collection = ProductVariant::with( 'product.owner' )->whereHas( 'product', function( $q ) use ( $categoryId )
            {
                $q->whereCategoryId($categoryId)->live();
            } )->inRandomOrder()->live(1)

but when i change the id to say 2 or 3.. I get same products.. is this something I have to take care of? or am i doing something wrong?

Environment

Laravel Version: 5.6.2
Laravel Model Caching Package Version: ^0.2.22
PHP Version: * 7.1.6 *
Homestead Version: N/A (using Valet)
Operating System & Version: *Mac OS - El captain - 10.11.6 *

[mikebronner]

Thanks for reporting this @shez1983 ! I'll take a look as soon as I get back to the office on Tuesday. In the mean time, can you provide the SQL representation of both queries?

[shez1983]

i'll make sure I update this post before tuesday.. Thanks :)

[mikebronner]

If you are able to, please include the stack trace as well. I do have about 30 minutes to look at it right now, if you are able to update the code :)

[mikebronner]

Related or same as #66

[mikebronner]

@shez1983 Are inRandomOrder() and live() query scopes? Can you paste them here as well? Thanks! :)