How to get a relation without the site scope?

#1

in some case, I need to fetch a list of course (which is multisite) and its respective category *which is multisite as well) without caring of the current site the user is on.

to fetch the courses works fine with

Course::withoutGlobalScopes()
...

then I need to fetch its category independently of the current site with

Course::withoutGlobalScopes()
            ->select(['title', 'category_id'])
            ->with(['category:id,name,slug'])
            ->get()

but the category defined in the course is not fetched on the other sites from which the course is defined on.
A solution would be duplicate all this courses on the others sites but that would be tedious.

Any idea please ?

#2

this seems to be working fine

->with(['category' => function ($q) {
                        $q->withoutGlobalScope(MultisiteScope::class);
                    },])
...
1 Like
#3

Yes, that looks like the way to do it!