Laravel query ->select && ->with

@webrobert It Never works for me... I don't know if the problem was Laravel or Livewire.

@hamzaelmaghari where is the Id in the select? And where is the with?

@webrobert This is my current model query sorry:

Page::query()
            ->orderBy('updated_at')
            ->select('id', 'title', 'state', 'created_at', 'updated_at')
            ->with('user:id,name')
            ->get();

@hamzaelmaghari well it works. So either you are missing the relationship or missing the correct related columns

@webrobert Every thing works if I use Model::all();

@webrobert The issue here is that user returns NULL

@MichalOravec I already included id as model property and then retuned null on relatioship dd();

@hamzaelmaghari And where is a foreign key in your query?

@MichalOravec

Page::query()
            ->orderBy('updated_at')
            ->select('id', 'title', 'state', 'created_at', 'updated_at')
            ->with('user:id,name')
            ->get();

@hamzaelmaghari User has many pages?

$pages = Page::with('user:id,name')
    ->select('id', 'user_id', 'title', 'state', 'created_at', 'updated_at')
    ->orderBy('updated_at')
    ->get();

@MichalOravec No, pages belongsTo User BTW ... everything works fine when retrieving model using Model::all();

@hamzaelmaghari @michaloravec refers to user_id or whatever is the FK on the pages table

Page::query()
            ->orderBy('updated_at')
            ->select('id', 'title', 'state', 'created_at', 'updated_at', 'user_id')
            ->with('user:id,name')
            ->get();

which you need in order to reference the user model

@hamzaelmaghari https://laracasts.com/series/laravel-8-from-scratch

Bye...

@Snapey It's classic user_id

Works, 👍

@hamzaelmaghari wow

@MichalOravec lmao 🤣

@webrobert I didn't include user_id in the select method .

@hamzaelmaghari,

@michaloravec and I both stated from the first reply. that you need the related Id. Aka the foreign id. Then @michaloravec gave the code example.

Then @snapey repost it. And you gave the repost the credit. 🤦🏽‍♂️