Laravel Ignore with defined in Eloquent Model

user_5515287 0
Viewed 274

I defined an Eloquent model in Laravel AssessmentCategory with a with relation with another Eloquent model AssessmentQuestion:

<?php

namespace App\Http\Models;
use Illuminate\Database\Eloquent\Model;

class AssessmentCategory extends Model {

    protected $table = 'assessment_categories';

    protected $with = ['questions'];

    public function scopeJsonColumns($query) {
        return $query->selectRaw('assessment_categories.id, assessment_categories.title');
    }

    public function questions() {
        return $this->hasMany(AssessmentQuestion::class, 'category_id');
    }
}

the AssessmentCategory now always loads its relation (child) data, but I want to call the AssessmentCategory somewhere without loading the relation (child) data.

AssessmentCategory::jsonColumns()->get();
eloquent laravel php
2 Answers

You can use without() Method when want to get data without relation.

AssessmentCategory::without('questions')->jsonColumns()->get();
user_130519410

There is multiple way to fix you problem.

  1. You can disable eager loading for current query at all:
AssessmentCategory::setEagerLoads([])->get();
  1. You can exclude only one relation from eager loading:
AssessmentCategory::without('questions')->get();
  1. Or you can disable eager loading at all by removing:
protected $with = ['questions'];

note that in this case you need yo overwrite all previous queries.

user_182868340
Related