hasMany() relation

[aivisionbot]

hello , Thank you for always answering our questions . I hope that you will help me in this matter because I have been struggling for several days and I could not find the right answer even by searching

i have an account model that belong to user mode :

 public function user() : BelongsTo {
        return $this->belongsTo(User::class);
    }

and user hasMany accounts :

 public function accounts(): \Illuminate\Database\Eloquent\Relations\HasMany
{
    return $this->hasMany(Account::class);
}

account have two type in my database : "binary" and "invest"
I want to display the binary account and invest of each user in two different columns in the users table:

     Column::make("Binary Account Balance", "accounts.balance")
            ->format(function ($value, $row) {
                $binaryAccount = $row->accounts()->where('type' , 'binary')->first();
                return $binaryAccount->balance;
            }),

But I get this error:
Rappasoft\LaravelLivewireTables\Views\Column::setTable(): Argument #1 ($table) must be of type string, null given, called in /home/mahdi/projects/vision/vendor/rappasoft/laravel-livewire-tables/src/Traits/Helpers/ColumnHelpers.php on line 26

I even used join in the builder, but I didn't get any results. Please help, thank you

[lrljoe]

Can you confirm which version you're using please :)

Is your table based off the "User" model?

Rather than adding a "join" to your builder(), add a "with" statement, so that it joins the relationship in an Eloquent manner.

Next, use setAdditionalSelects() in your configure() method to ensure that relevant fields are selected from the related models.

Finally, you should then be able to use a "label()" rather than a format() column to achieve what you want, which will avoid the package trying to figure out the table

     Column::make("Binary Account Balance")
            ->label(function ($row) {
                $binaryAccount = $row->accounts()->where('type' , 'binary')->first();
                return $binaryAccount->balance;
            }),

[aivisionbot]

I use version 3 .
I did what you said and my problem was solved, but I have two points now:
1 - The columns I added are not sortable
2- and For each row I have, a query is added and this problem creates N+1 Query Problem.
My code is as follows:

       public function configure(): void
          {
              $this->setPrimaryKey('id')
                  ->setDefaultSort('id', 'desc')
          }
          
          
           public function builder(): Builder
            {
                $query = User::query()->with('accounts');
        
                return $query ;
            }
            
            
            public function columns(): array
          {
          return [
              Column::make("Id", "id")
                  ->sortable(),
                  
                    Column::make("Name", "name"),
                    
                    Column::make("Binary Account Balance")
            ->label(function ($row) {
                $binaryAccount = $row->accounts()->where('type' , AccountTypeEnum::BINARY->value)->first();
                return $binaryAccount->balance;
            })->sortable(),

        Column::make("Invest Account Balance")
            ->label(function ($row) {
                $investAccount = $row->accounts()->where('type' , AccountTypeEnum::INVEST->value)->first();
                return $investAccount->balance;
            })->sortable(),
            
             ];
        }