How we get specific columns from multiple relations using With() in Laravel

Question

I need some specific columns from two relations.

In my questions model I have two relations

public function ans_options()
{
 return $this->hasMany('App\Models\AnswerChoices', 'ac_quest_id', 'q_id');
}
public function question_category()
{

 return $this->hasOne("App\Models\Categories", 'cat_id', 'q_category');
}

I tried

Questions::with(array(
                'questionCategory' => function($query) {$query->select('cat_id','cat_value');},
                'ans_options' => function($query1) {$query1->select('ac_id','ac_choiceTxt');}
               ))->get();

am getting only the columns of question_category not in ans_options

{
  "q_id": 349,
  "q_project_id": 140,
  "q_text": "<p>Gender</p>",
  "question_category": {
    "cat_id": 1,
    "cat_value": "normal"
  },
  "ans_options": []
}

But when I try the below code all columns of ans_options are getting.

Questions::with('questionCategory:cat_id,cat_value','ans_options')->get();

like

{
  "q_id": 349,
  "q_project_id": 140,
  "q_text": "<p>Gender</p>",
  "question_category": {
    "cat_id": 1,
    "cat_value": "normal"
  },
  "ans_options": [
    {
      "ac_id": 334,
      "ac_quest_id": 349,
      "ac_choiceTxt": "Male",
      "ac_modifiedOn": "2021-11-24T06:22:00.000000Z",
      "ac_status": "active"
    },
    {
      "ac_id": 335,
      "ac_quest_id": 349,
      "ac_choiceTxt": "Female",
      "ac_modifiedOn": "2021-11-24T06:22:00.000000Z",
      "ac_status": "active"
    }
  ]
}

I need only ac_id and ac_choiceTxt from ans_options. How can I achieve that?

Mohammad Fanni · Accepted Answer · 2022-09-03 10:10:54Z

2

to make Laravel able to load the relation, you should select the foreign key that responsible for that relation

Questions::with(array(
    'questionCategory' => function ($query) {
        $query->select('cat_id', 'cat_value');
    },
    'ans_options' => function ($query1) {
        $query1->select(
            'ac_id',
            'ac_choiceTxt',
            'ac_quest_id'
        );
    }
))->get();

just add 'ac_quest_id' to your select.

edited Sep 3, 2022 at 10:10

Mohammad Fanni

4,2033 gold badges31 silver badges55 bronze badges

answered Nov 24, 2021 at 8:21

OMR

12.3k5 gold badges26 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Никита Середа · Accepted Answer · 2021-11-24 08:24:54Z

0

You can make model where available only this fields
Extend current model from new (with removing columns from curent)
use "with" from new short model

I don't know another way at now...

answered Nov 24, 2021 at 8:24

Никита Середа

2,0861 gold badge20 silver badges39 bronze badges

Comments

Jyothi · Accepted Answer · 2021-11-24 08:40:58Z

0

Then we can add the primary key here also. It will get the same result and then no need of closures here.

Questions::with('questionCategory:cat_id,cat_value',
   'ans_options:ac_id,ac_choiceTxt,ac_quest_id')
 ->get();

answered Nov 24, 2021 at 8:40

Jyothi

731 silver badge9 bronze badges

Collectives™ on Stack Overflow

How we get specific columns from multiple relations using With() in Laravel

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related