F
Filament•9mo ago
UncleBen

Display count of relationship in table column where pivot value = something

Hi, I need to access the many to many relationship of a model in a column and display the count of the relationship where a pivot value equals a certain value. How can I go about this? The eloquent query for this would be $model->relationship()->wherePivot('status', 'active')->count(); I just can't work out how to do this using the documentation. Or is this something I should just add to the laravel model using a getAttribute method? Thanks,
1 Reply
ChesterS
ChesterS•9mo ago
There is a counts('relation') method on the columns. eg 
TextColumn::make('users_count')->counts('users');
TextColumn::make('users_count')->counts('users');
But I'm not sure where it's documented or how exactly it works. If not, you can try 
->getStateUsing(fn(Model $record) => $record->relationship->count())
->getStateUsing(fn(Model $record) => $record->relationship->count())
(use with('relationship') on the original query to reduce N+1 issue
Want results from more Discord servers?
Add your server
More Posts
Custom Action that calls "save" doesn't actually save the modelSo I'm trying to put a save button elsewhere in an Edit page ``` Grid::make('card_payment') ->viInteract with input state and events using AlpineI'm trying to create a custom Radio input that would allow to render another text input next to optirecordSelectSearchColumns on GetRelationHello friends, I have a question, I'm in a get relation and I want in an attach action to do a searcHow to make two column section using grid?Hello everyone, I just want to ask how do I make a 2 column section using grid? I have set the columFileUpload download/preview file from private storageHi, is it possible to simply download a file from private storage? I've tried this, but this doesn'Resume Supported Form like Tax submission or Visa Application formI want to make a huge form with almost 10 tables. Initially I want to create a small table like projMax excution timeoutsI tried a fresh Laravel install and did the first Getting Started steps. When I try to go to /admin/Create and Edit from RelationManager without modalThis is probably a question that might be answered somewhere, but I can't find it. I want to create