Referensi Tables

PandaPanel\Tables\TableSchema dan seluruh komponen yang berada di dalamnya mencakup:

columns;
filters;
groups;
tabs;
summaries;
actions;
selection;
editable cells;
serta TableQuery yang mengubah state URL menjadi query Eloquent yang sudah dibatasi.

Pada PandaBear, URL merupakan state dari Table.

State tersebut mencakup:

text

page
per-page
search
sort
direction
filters
columns
group

Dengan pendekatan ini:

tombol Back bekerja;
tombol Forward bekerja;
refresh mempertahankan Table;
bookmark mempertahankan filter;
URL Table dapat dibagikan kepada user lain.

Namespaces

Class	Kegunaan
`PandaPanel\Tables\TableSchema`	Declarative description dari sebuah Table
`PandaPanel\Tables\TableQuery`	Menerapkan URL state ke Eloquent query
`PandaPanel\Tables\ArrayTableData`	Table Schema yang sama untuk record non-database
`PandaPanel\Tables\Group`	Mengelompokkan row menjadi beberapa band
`PandaPanel\Tables\Tab`	Filter tab di atas List Page
`PandaPanel\Tables\Columns\Column`	Base class seluruh Column
`PandaPanel\Tables\Columns\EditableColumn`	Base class seluruh writable Column
`PandaPanel\Tables\Columns\Concerns\HasRelationshipState`	Aggregate dan relation sorting untuk seluruh Column
`PandaPanel\Tables\Filters\Filter`	Base class seluruh Filter
`PandaPanel\Tables\Filters\Constraints\Constraint`	Satu Column yang dapat dibatasi Query Builder Filter
`PandaPanel\Tables\Summaries\Summarizer`	Satu nilai summary di bawah Column
`PandaPanel\Tables\Enums\*`	Closed set enum yang dikirim ke Vue

Contoh Table yang Berfungsi

php

<?php

namespace App\Panels\Admin\Resources\Users\Tables;

use PandaPanel\Actions\DeleteAction;
use PandaPanel\Actions\EditAction;
use PandaPanel\Tables\Columns\BooleanColumn;
use PandaPanel\Tables\Columns\DateColumn;
use PandaPanel\Tables\Columns\TextColumn;
use PandaPanel\Tables\Enums\SortDirection;
use PandaPanel\Tables\Filters\TernaryFilter;
use PandaPanel\Tables\TableSchema;

final class UsersTable
{
    public static function configure(
        TableSchema $table
    ): TableSchema {
        return $table
            ->columns([
                TextColumn::make('name')
                    ->searchable()
                    ->sortable(),

                TextColumn::make('email')
                    ->searchable(),

                BooleanColumn::make('is_admin')
                    ->label('Admin'),

                DateColumn::make('created_at')
                    ->label('Joined')
                    ->sortable(),
            ])
            ->filters([
                TernaryFilter::make('is_admin')
                    ->label('Administrator'),
            ])
            ->defaultSort(
                'created_at',
                SortDirection::Descending
            )
            ->recordActions([
                EditAction::make(
                    UserResource::class
                ),

                DeleteAction::make(
                    UserResource::class
                ),
            ]);
    }
}

Gunakan dari Resource:

php

public static function table(
    TableSchema $table
): TableSchema {
    return UsersTable::configure(
        $table
    );
}

`TableSchema`

TableSchema merupakan:

php

final class TableSchema

Seluruh builder method mengembalikan:

php

self

Content

API:

php

public static function make(): self;

public function columns(
    array $columns
): self;
// array<array-key, Column>

public function filters(
    array $filters
): self;
// array<array-key, Filter>

public function groups(
    array $groups
): self;
// array<array-key, Group>

public function defaultGroup(
    string $name
): self;

Duplicate Column dan Filter

columns() dan filters() menolak duplicate name melalui:

php

PandaPanel\Exceptions\PanelSchemaException

Hal ini penting karena nama Column menjadi key untuk:

cell;
visibility state;
search;
sort.

Sedangkan nama Filter menjadi key pada query string.

Contohnya:

text

filters[status]=live

Jika dua Filter menggunakan nama:

text

status

tidak ada jawaban yang jelas Filter mana yang seharusnya menerima value tersebut.

Karena itu duplicate ditolak pada schema.

Sorting, Searching, dan Paging

API:

php

public function defaultSort(
    string $column,
    SortDirection $direction =
        SortDirection::Descending
): self;

public function defaultSortOptionLabel(
    string $label
): self;
// null

public function perPageOptions(
    array $options
): self;
// [10, 25, 50, 100]

public function defaultPerPage(
    int $perPage
): self;
// 25

public function searchPlaceholder(
    string $placeholder
): self;
// 'Search...'

public function searchDebounce(
    int $milliseconds
): self;
// 300

public function searchOnBlur(
    bool $onBlur = true
): self;
// false

public function splitSearchTerms(
    bool $split = true
): self;
// true

`splitSearchTerms()`

Default:

php

true

Artinya setiap kata dalam search harus menemukan match di suatu tempat.

Contoh query:

text

ada lovelace

Jika Table memiliki:

text

first_name
last_name

maka pencarian dapat diperlakukan sebagai:

text

ada
AND
lovelace

sehingga:

text

first_name = Ada
last_name = Lovelace

dapat ditemukan.

Jika seluruh input diperlakukan sebagai satu string:

text

"ada lovelace"

tidak ada satu Column pun yang memiliki exact sequence tersebut.

Unknown Default Sort

Jika:

php

->defaultSort(
    'created_at'
)

digunakan tetapi Table tidak memiliki Column:

text

created_at

framework melempar:

php

PanelSchemaException::unknownDefaultSort()

Pemeriksaan dilakukan ketika:

php

toArray()

bukan langsung dari setter.

Alasannya, valid configuration dapat menulis:

php

->defaultSort(...)

sebelum:

php

->columns(...)

Jika tidak diperiksa, Table akan silently menggunakan natural query order tanpa menjelaskan mengapa konfigurasi sort tidak bekerja.

Persistence dan Deferral

API:

php

public function persistSearchInSession(
    bool $persist = true
): self;
// false

public function persistSortInSession(
    bool $persist = true
): self;
// false

public function persistFiltersInSession(
    bool $persist = true
): self;
// false

public function persistColumnsInSession(
    bool $persist = true
): self;
// false

public function deferFilters(
    bool $defer = true
): self;
// false

public function deferColumnManager(
    bool $defer = true
): self;
// false

Request Selalu Mengalahkan Session

Jika parameter request ada, request memiliki prioritas.

Bahkan ketika parameter tersebut sengaja dikosongkan.

Contohnya session menyimpan:

text

search = alan

kemudian user clear search sehingga URL membawa:

text

?search=

request kosong tersebut harus tetap menang.

Jika tidak, Table akan membaca session kembali dan search yang baru saja dihapus muncul lagi.

Karena itu fallback ke session hanya terjadi jika parameter request tidak ada sama sekali.

Filter Bar dan Column Manager

API:

php

public function filtersTrigger(
    string $label,
    ?string $icon = null
): self;
// 'Filters', null

public function filtersApplyLabel(
    string $label
): self;
// 'Apply filters'

public function filtersResetLabel(
    string $label
): self;
// 'Clear'

public function showFiltersResetAction(
    bool $show = true
): self;
// true

public function reorderableColumns(
    bool $reorderable = true
): self;
// false

public function columnManagerTrigger(
    string $label,
    ?string $icon = null
): self;
// 'Columns', null

public function columnManagerInModal(
    bool $inModal = true
): self;
// false

public function showColumnManagerReset(
    bool $show = true
): self;
// true

Label reset milik Column Manager selalu:

text

Reset

Yang dapat dikonfigurasi hanya apakah Action tersebut:

text

ditampilkan
atau
disembunyikan

Rows, Selection, dan Actions

API:

php

public function selectable(
    bool $selectable = true
): self;
// false

public function reorderable(
    string $column
): self;
// juga melakukan
// defaultSort($column, Ascending)

public function recordActions(
    array $actions
): self;

public function recordActionsPosition(
    RecordActionsPosition $position
): self;
// AfterColumns

public function recordActionsLabel(
    string $label
): self;
// null

public function bulkActions(
    array $actions
): self;
// otomatis selectable(true)
// jika tidak kosong

public function headerActions(
    array $actions
): self;

public function toolbarActions(
    array $actions
): self;

public function emptyStateActions(
    array $actions
): self;

public function frozenActions(
    bool $frozen = true
): self;
// false

Action Validation

Setiap Action setter memeriksa:

duplicate Action names;
inert Action.

Duplicate menghasilkan:

php

PanelSchemaException::duplicateActions()

Sedangkan Action yang tidak memiliki:

URL;
handler;
Form;
Modal;

menghasilkan:

php

PanelSchemaException::inertAction()

Framework tidak membiarkan button dirender jika ketika diklik tidak dapat melakukan apa pun.

`bulkActions()` Mengaktifkan Selection

Jika:

php

->bulkActions([
    // ...
])

tidak kosong, Table otomatis menjadi:

php

selectable(true)

Karena Bulk Action tanpa row selection tidak dapat digunakan.

Reorderable Table

php

$table->reorderable(
    'position'
);

selain mengaktifkan drag reorder juga secara otomatis menggunakan:

php

defaultSort(
    'position',
    SortDirection::Ascending
)

Table reorderable yang disortir berdasarkan Column lain akan menampilkan urutan yang tidak sesuai dengan drag handle.

Empty State

API:

php

public function emptyState(
    string $heading,
    ?string $description = null,
    ?string $icon = null
): self;

public function emptyStateComponent(
    string $component
): self;
// null

Default heading:

text

No records found

Membaca Schema

API:

php

public function getColumns(): array;
// list<Column>

public function getColumn(
    string $name
): ?Column;

public function columnNames(): array;

public function defaultVisibleColumnNames():
    array;

public function toggleableColumnNames():
    array;

public function getSortableColumns():
    array;

public function getSearchColumns():
    array;
// local columns only

public function getSearchRelations():
    array;
// dotted paths

public function isSearchable():
    bool;

public function getIndividuallySearchableColumns():
    array;

public function getIndividuallySearchableColumn(
    string $name
): ?Column;

public function getFilters():
    array;

public function getFilter(
    string $name
): ?Filter;

public function defaultFilters():
    array;

public function persistsFiltersInSession():
    bool;

public function defersFilters():
    bool;

public function persistsSearchInSession():
    bool;

public function persistsSortInSession():
    bool;

public function persistsColumnsInSession():
    bool;

public function hasReorderableColumns():
    bool;

public function shouldSplitSearchTerms():
    bool;

public function getGroups():
    array;

public function getGroup(
    string $name
): ?Group;

public function getDefaultGroup():
    ?string;

public function getDefaultSortColumn():
    ?string;

public function getDefaultSortDirection():
    SortDirection;

public function getPerPageOptions():
    array;

public function getDefaultPerPage():
    int;

public function isSelectable():
    bool;

public function isReorderable():
    bool;

public function getReorderColumn():
    ?string;

public function hasFrozenActions():
    bool;

public function hasFrozenStart():
    bool;

public function getRecordActions():
    array;

public function getBulkActions():
    array;

public function getHeaderActions():
    array;

public function getToolbarActions():
    array;

public function getEmptyStateActions():
    array;

public function getRecordAction(
    string $name
): ?Action;

public function getBulkAction(
    string $name
): ?Action;

public function getTableAction(
    string $name
): ?Action;

public function hasSummaries():
    bool;

public function applyColumnQueries(
    Builder $query
): void;

Action Lookup adalah Whitelist

Method:

php

getRecordAction()
getBulkAction()
getTableAction()

merupakan whitelist yang digunakan Action endpoint.

Jika request mengirim:

text

action = delete

tetapi delete tidak ditemukan dalam schema sesuai scope, Action tersebut dianggap:

text

tidak ada

Apa pun string yang dikirim client tidak dapat membuat Action baru.

Menghasilkan Payload

API:

php

public function toArray(): array;
// Table definition

public function toRow(
    Model $record,
    ?Group $group = null
): array;
// one row

public function summaries(
    Builder $query,
    array $records
): array;

public function groupSummaries(
    Builder $query,
    array $records,
    Group $group
): array;

`toRow()`

Satu row memiliki bentuk:

text

key
group
cells
cellMeta
actions

Secara konsep:

php

[
    'key' => ...,
    'group' => ...,
    'cells' => [...],
    'cellMeta' => [...],
    'actions' => [...],
]

Cell metadata dipisahkan dari value.

Dengan begitu sebuah cell value dapat mempertahankan shape yang tepat sesuai renderer Column-nya.

`TableQuery`

TableQuery merupakan:

php

final readonly class TableQuery

Constructor:

php

public function __construct(
    TableSchema $schema,
    Request $request,
    ?string $namespace = null,
    ?string $sessionKey = null,
);

API:

php

public function namespace():
    ?string;

public function constrain(
    Builder $query
): void;

public function paginate(
    Builder $query
): LengthAwarePaginator;

public function paginateRelation(
    Relation $relation
): LengthAwarePaginator;

public function activeGroup():
    ?Group;

public function state(): array;

Contoh `TableQuery`

php

use PandaPanel\Tables\TableQuery;
use PandaPanel\Tables\TableSchema;

$schema =
    UserResource::table(
        TableSchema::make()
    );

$query =
    new TableQuery(
        $schema,
        $request,
        sessionKey:
            'panel.admin.table.users',
    );

$records =
    $query->paginate(
        UserResource::query()
    );

$rows =
    array_map(
        fn ($record) =>
            $schema->toRow(
                $record
            ),
        $records->items()
    );

$state =
    $query->state();

Urutan Constraint

constrain() menerapkan operasi dalam urutan:

Column queries;
base-query filters;
global search;
per-column searches;
filters;
sort.

Column query dapat mencakup:

aggregates;
relation sorting requirements.

`paginate()`

paginate():

memanggil constrain();
melakukan pagination;
menggunakan:

php

withQueryString()

sehingga state URL tetap dibawa ke link pagination.

TableQuery Tidak Memulai Query

TableQuery tidak melakukan:

php

Model::query()

sendiri.

Sebaliknya ia menerima query yang sudah dibuat Resource.

Contoh:

php

$query->paginate(
    UserResource::query()
);

Dengan begitu scope milik Resource tetap aktif:

tenancy;
module;
permission;
parent Resource;
per-Panel query modification.

Query Parameters

Semua value dari query string divalidasi terhadap Table Schema sebelum menyentuh Builder.

Unknown parameter tidak diteruskan begitu saja.

Parameter	Divalidasi terhadap
`page`	`max(1, (int) $value)`
`perPage`	`perPageOptions()`, jika invalid gunakan default
`search`	trim dan maksimal 255 karakter
`columnSearch[{column}]`	Column dengan `searchable(individually: true)`
`sort`	Column dengan `sortable()`
`direction`	`SortDirection`; unknown menjadi ascending
`filters[{name}]`	`sanitize()` milik Filter
`group`	Group yang dideklarasikan
`columns`	declared Column names; non-toggleable Column selalu dimasukkan kembali ke visible

Query String adalah User Input

Contoh:

text

?sort=password

jika password bukan sortable Column:

text

diabaikan

bukan diteruskan ke:

php

orderBy(
    'password'
)

Hal yang sama berlaku untuk Filter, Group, dan visibility Column.

`state()`

Shape:

php

[
    'search' =>
        ?string,

    'sort' =>
        ?string,

    'direction' =>
        'asc'|'desc',

    'perPage' =>
        int,

    'filters' =>
        array<string, mixed>,

    'filterIndicators' =>
        array<string, string>,

    'columnSearches' =>
        array<string, string>,

    'columns' => [
        'visible' =>
            list<string>,

        'order' =>
            list<string>,
    ],

    'group' =>
        ?string,
]

State ini menjadi representasi backend dari kondisi Table saat ini.

Namespaces

Namespace memindahkan seluruh state Table ke satu nested query-string key.

Contoh:

php

new TableQuery(
    $schema,
    $request,
    namespace:
        'relations.tasks'
);

URL:

text

?relations[tasks][sort]=title
&relations[tasks][page]=2

Mengapa Namespace Diperlukan

Sebuah View/Edit Record dapat memiliki beberapa relation table sekaligus.

Contoh:

text

User
├── Orders Table
├── Tasks Table
└── Sessions Table

Jika semuanya memakai:

text

?page=2

maka mengubah page Tasks juga mengubah Orders dan Sessions.

Dengan namespace:

text

relations[orders][page]
relations[tasks][page]
relations[sessions][page]

masing-masing Table memiliki state sendiri.

`Column`

Base class:

php

abstract class Column

Semua setter mengembalikan:

php

static

Identity dan Behaviour

API:

php

public static function make(
    string $name
): static;

public function label(
    string $label
): static;
// Str::headline($name)

public function sortable(
    bool $sortable = true,
    ?string $column = null
): static;
// false

public function searchable(
    bool $searchable = true,
    ?array $columns = null,
    bool $individually = false
): static;

public function sortUsing(
    Closure $callback
): static;

public function visible(
    bool $visible = true
): static;
// true

public function toggleable(
    bool $toggleable = true
): static;
// true

`searchable()`

Secara sederhana:

php

TextColumn::make('name')
    ->searchable();

mencari Column tersebut.

Tetapi Anda juga dapat menentukan Column lain:

php

TextColumn::make('full_name')
    ->searchable(
        columns: [
            'first_name',
            'last_name',
        ]
    );

Dotted path berarti relation.

Contoh:

php

->searchable(
    columns: [
        'author.name',
    ]
)

Jika:

php

individually: true

Column juga memiliki search input sendiri.

Presentation

API:

php

public function alignment(
    Alignment|string $alignment
): static;
// Start

public function headerAlignment(
    Alignment|string $alignment
): static;
// mengikuti alignment

public function placeholder(
    string $placeholder
): static;
// null

public function default(
    mixed $default
): static;
// null

public function tooltip(
    Closure|string $tooltip
): static;

public function headerTooltip(
    string $tooltip
): static;

public function wrapHeader(
    bool $wrap = true
): static;
// false

public function width(
    string $width
): static;
// null

public function frozen(
    ColumnPin|bool $pin = true
): static;
// null

public function extraAttributes(
    Closure|array $attributes
): static;

public function formatUsing(
    Closure $callback
): static;

`width()`

width() menerima CSS length.

Contoh:

php

->width('12rem')

atau:

php

->width('180px')

Value ini menjadi inline style, bukan Tailwind runtime class.

Frozen Columns

php

->frozen()

atau:

php

->frozen(true)

mem-pin Column ke:

text

Start

Untuk sisi lain:

php

->frozen(
    ColumnPin::End
)

Links, Actions, dan Summaries

API:

php

public function url(
    Closure $callback
): static;

public function action(
    Action $action
): static;

public function getAction():
    ?Action;

public function summarize(
    array $summarizers
): static;

public function getSummarizers():
    array;

public function hasSummaries():
    bool;

public function summaryColumn():
    string;

Reading Column

API:

php

public function getName():
    string;

public function getLabel():
    string;

public function isSortable():
    bool;

public function isVisible():
    bool;

public function isToggleable():
    bool;

public function isSearchable():
    bool;

public function isIndividuallySearchable():
    bool;

public function hasCustomSort():
    bool;

public function getSortColumn():
    string;

public function getSearchColumns():
    array;

public function getFrozen():
    ?ColumnPin;

public function resolveValue(
    Model $record
): mixed;

public function toCellMeta(
    Model $record
): ?array;

public function applyCustomSort(
    Builder $query,
    SortDirection $direction
): void;

public function toArray():
    array;

abstract public function type():
    ColumnType;

Column Types

Class	`ColumnType`	Method Khusus	Default Penting
`TextColumn`	`Text`	`limit(int)`, `wrap(bool = true)`	—
`NumberColumn`	`Number`	`decimals(int)`, `prefix(string)`, `suffix(string)`	`decimals` 0, alignment `End`
`BadgeColumn`	`Badge`	`colors(array)`, `labels(array)`	—
`BooleanColumn`	`Boolean`	`labels(string $true, string $false)`	`Yes` / `No`, alignment `Center`
`DateColumn`	`Date`	`format(string)`, `relative(bool = true)`	`'M j, Y'`
`DateTimeColumn`	`DateTime`	extends `DateColumn`	`'M j, Y H:i'`
`ImageColumn`	`Image`	`circular(bool = true)`, `size(int)`, `fallbackUsing(Closure)`	32 px, square
`IconColumn`	`Icon`	`icons(array)`, `colors(array)`, `iconUsing(Closure)`, `boolean(string $true = 'check', string $false = 'x')`	alignment `Center`
`ColorColumn`	`Color`	`copyable(bool = true)`	false
`CustomColumn`	`Custom`	`component(string)`, `state(Closure)`	—
`TextInputColumn`	`TextInput`	`numeric()`, `maxLength(int)`	writable
`SelectColumn`	`Select`	`options(array)`	writable
`ToggleColumn`	`Toggle`	—	writable, alignment `Center`
`CheckboxColumn`	`Checkbox`	—	writable, alignment `Center`

Contoh Column

php

use PandaPanel\Tables\Enums\BadgeColor;

BadgeColumn::make('status')
    ->colors([
        'live' =>
            BadgeColor::Success,

        'draft' =>
            BadgeColor::Neutral,
    ])
    ->labels([
        'live' =>
            'Live',

        'draft' =>
            'Draft',
    ]);

DateColumn::make('created_at')
    ->format('Y-m-d')
    ->relative();

IconColumn::make('is_admin')
    ->boolean(
        'shield',
        'x'
    );

CustomColumn::make(
    'account_age'
)
    ->component(
        'Panels/Admin/Columns/AccountAge'
    )
    ->state(
        fn (
            Model $record
        ): int =>
            $record
                ->created_at
                ->diffInDays()
    );

Custom Column Component

CustomColumn::component() menerima build-time registry key.

Contoh:

text

Panels/Admin/Columns/AccountAge

merupakan path di bawah:

text

resources/js/pages/

tanpa extension.

Executable Closure tetap dijalankan di server melalui:

php

state()

Frontend hanya menerima hasil state.

`EditableColumn`

EditableColumn adalah base class untuk empat Column writable:

text

TextInputColumn
SelectColumn
ToggleColumn
CheckboxColumn

Write cell dikirim ke:

text

panel.{id}.actions.cell

Cell write diperlakukan seperti Action dalam hal yang penting:

memiliki record;
melakukan authorization;
melakukan validation;
mengubah data.

EditableColumn API

php

public function rules(
    array $rules
): static;

public function disabledUsing(
    Closure $callback
): static;

public function mutateUsing(
    Closure $callback
): static;

public function updateUsing(
    Closure $callback
): static;

public function writeTo(
    string $attribute
): static;

public function getWriteAttribute():
    string;

public function isDisabledFor(
    Model $record
): bool;

public function validationRules():
    array;

public function write(
    Model $record,
    mixed $value
): void;

Editable Column Examples

Disabled berdasarkan record:

php

ToggleColumn::make(
    'is_published'
)
    ->disabledUsing(
        fn (
            Model $record
        ): bool =>
            $record
                ->archived_at
                !== null
    );

Menulis ke attribute berbeda:

php

TextInputColumn::make('sku')
    ->rules([
        'string',
        'max:32',
    ])
    ->writeTo(
        'stock_keeping_unit'
    );

Custom update behavior:

php

SelectColumn::make('status')
    ->options([
        'draft' =>
            'Draft',

        'live' =>
            'Live',
    ])
    ->updateUsing(
        function (
            mixed $value,
            Model $record
        ): void {
            app(
                PublishPost::class
            )->run(
                $record,
                $value
            );
        }
    );

`HasRelationshipState`

Trait:

php

PandaPanel\Tables\Columns\Concerns\HasRelationshipState

digunakan oleh:

php

Column

Karena itu seluruh Column memiliki kemampuan relation aggregate dan relation sorting.

API:

php

public function counts(
    string $relation
): static;

public function exists(
    string $relation
): static;

public function sum(
    string $relation,
    string $column
): static;

public function avg(
    string $relation,
    string $column
): static;

public function min(
    string $relation,
    string $column
): static;

public function max(
    string $relation,
    string $column
): static;

public function sortableByRelation(
    string $relation,
    string $column
): static;

public function getAggregateRelation():
    ?string;

public function getSortRelation():
    ?string;

public function aggregateAttribute():
    ?string;

public function applyQuery(
    Builder $query
): void;

public function applyRelationshipSort(
    Builder $query,
    SortDirection $direction
): void;

public function summaryUsesAggregate():
    bool;

Aggregate Examples

Count relation:

php

NumberColumn::make('posts')
    ->counts('posts')
    ->sortable();

Sum:

php

NumberColumn::make('revenue')
    ->sum(
        'orders',
        'total'
    )
    ->decimals(2);

Sort berdasarkan relation:

php

TextColumn::make('author')
    ->sortableByRelation(
        'author',
        'name'
    );

Aggregate Tidak Melakukan Query per Row

Aggregate ditambahkan ke base query menggunakan mekanisme Eloquent seperti:

php

withCount()
withSum()

Kemudian Column membaca generated attribute.

Artinya:

text

100 rows

tidak menghasilkan:

text

100 relation aggregate queries

`RelationshipAggregate`

Pilihan:

php

RelationshipAggregate::Count

RelationshipAggregate::Exists

RelationshipAggregate::Sum

RelationshipAggregate::Avg

RelationshipAggregate::Min

RelationshipAggregate::Max

Filters

Base class:

php

abstract class Filter

API:

php

public static function make(
    string $name
): static;

public function label(
    string $label
): static;
// Str::headline($name)

public function column(
    string $column
): static;
// default name

public function query(
    Closure $callback
): static;

public function modifyBaseQueryUsing(
    Closure $callback
): static;

public function default(
    mixed $value
): static;

public function hasDefault():
    bool;

public function getDefault():
    mixed;

public function apply(
    Builder $query,
    mixed $value
): void;

public function applyBaseQuery(
    Builder $query,
    mixed $value
): void;

public function indicator(
    mixed $value
): ?string;

public function toArray():
    array;

abstract public function type():
    FilterType;

abstract public function sanitize(
    mixed $value
): mixed;

`sanitize()` adalah Whitelist

Query string adalah user input.

Setiap Filter menentukan sendiri value apa yang valid melalui:

php

sanitize()

Jika value tidak dapat digunakan:

php

null

dikembalikan.

Client tidak dapat memaksa arbitrary value langsung masuk ke Builder.

Filter Types

Class	`FilterType`	Method Khusus
`SelectFilter`	`Select`	`options(array)`, `placeholder(string)`
`BooleanFilter`	`Boolean`	`labels(string $true, string $false)`, `nullable(bool = true)`
`TernaryFilter`	`Ternary`	`labels(string $true, string $false, ?string $blank = null)`, `nullable(bool = true)`, `queries(Closure $true, Closure $false)`
`DateFilter`	`Date`	—
`TrashedFilter`	`Select`	tiga fixed option: `without`, `with`, `only`
`FormFilter`	`Form`	`form(Closure)`, `schema()`
`QueryBuilderFilter`	`QueryBuilder`	`constraints(array)`, `maxRules(int)`, `constraint(string)`

Default blank label TernaryFilter:

text

All

Default label BooleanFilter dan TernaryFilter:

text

Yes
No

Filter Examples

php

use PandaPanel\Tables\Filters\SelectFilter;
use PandaPanel\Tables\Filters\TernaryFilter;
use PandaPanel\Tables\Filters\TrashedFilter;

SelectFilter::make('status')
    ->options([
        'draft' =>
            'Draft',

        'live' =>
            'Live',
    ])
    ->placeholder(
        'Any status'
    )
    ->default(
        'live'
    );

TernaryFilter::make(
    'verified'
)
    ->labels(
        'Verified',
        'Unverified'
    )
    ->queries(
        function (
            Builder $query
        ): void {
            $query
                ->whereNotNull(
                    'email_verified_at'
                );
        },

        function (
            Builder $query
        ): void {
            $query
                ->whereNull(
                    'email_verified_at'
                );
        },
    );

TrashedFilter::make(
    'trashed'
);

TrashedFilter secara visual menggunakan konsep:

text

Deleted records

Hidden
Included
Only deleted

Filter ini membutuhkan Resource yang memang mengaktifkan:

php

$softDeletes

agar record deleted dapat dijangkau.

`FormFilter`

FormFilter membawa satu FormSchema.

Ini memungkinkan satu Filter terdiri dari beberapa field.

Contoh date range:

php

use PandaPanel\Forms\Components\DatePicker;
use PandaPanel\Forms\FormSchema;
use PandaPanel\Tables\Filters\FormFilter;

FormFilter::make('created')
    ->form(
        fn (
            FormSchema $schema
        ): FormSchema =>
            $schema->schema([
                DatePicker::make(
                    'from'
                ),

                DatePicker::make(
                    'until'
                ),
            ])
    )
    ->query(
        function (
            Builder $query,
            mixed $value
        ): void {
            $query
                ->when(
                    $value['from']
                        ?? null,

                    fn (
                        $q,
                        $from
                    ) =>
                        $q->whereDate(
                            'created_at',
                            '>=',
                            $from
                        )
                )
                ->when(
                    $value['until']
                        ?? null,

                    fn (
                        $q,
                        $until
                    ) =>
                        $q->whereDate(
                            'created_at',
                            '<=',
                            $until
                        )
                );
        }
    );

Satu Filter:

text

created

memiliki dua input:

text

from
until

Query Builder Constraints

QueryBuilderFilter dibangun dari beberapa:

php

Constraint

Setiap Constraint mendeskripsikan:

Column;
operators yang didukung;
bagaimana value divalidasi;
bagaimana query diterapkan.

Base:

php

abstract class Constraint
{
    public static function make(
        string $name
    ): static;

    public function label(
        string $label
    ): static;

    public function column(
        string $column
    ): static;

    public function getName():
        string;

    public function getLabel():
        string;

    public function getColumn():
        string;

    public function supports(
        ConstraintOperator $operator
    ): bool;

    public function accepts(
        ConstraintOperator $operator,
        mixed $value
    ): bool;

    public function apply(
        Builder $query,
        ConstraintOperator $operator,
        mixed $value
    ): void;

    public function toArray():
        array;

    abstract public function inputType():
        string;

    abstract public function operators():
        array;
}

Constraint types:

text

TextConstraint
NumberConstraint
DateConstraint
BooleanConstraint

QueryBuilderFilter Example

php

use PandaPanel\Tables\Filters\Constraints\NumberConstraint;
use PandaPanel\Tables\Filters\Constraints\TextConstraint;
use PandaPanel\Tables\Filters\QueryBuilderFilter;

QueryBuilderFilter::make('query')
    ->maxRules(5)
    ->constraints([
        TextConstraint::make(
            'name'
        ),

        NumberConstraint::make(
            'orders_count'
        )
            ->label(
                'Orders'
            ),
    ]);

Default:

text

maxRules = 10

`ConstraintOperator`

Available operators:

php

ConstraintOperator::Contains

ConstraintOperator::DoesNotContain

ConstraintOperator::StartsWith

ConstraintOperator::EndsWith

ConstraintOperator::EqualTo

ConstraintOperator::NotEqualTo

ConstraintOperator::GreaterThan

ConstraintOperator::GreaterThanOrEqual

ConstraintOperator::LessThan

ConstraintOperator::LessThanOrEqual

ConstraintOperator::IsFilled

ConstraintOperator::IsBlank

ConstraintOperator::IsTrue

ConstraintOperator::IsFalse

Masing-masing menyediakan:

php

label()

needsValue()

Summaries

Base:

php

abstract class Summarizer
{
    public static function make(
        string $name = ''
    ): static;

    public function label(
        string $label
    ): static;

    public function formatUsing(
        Closure $callback
    ): static;

    public function perPage(
        bool $perPage = true
    ): static;
    // false

    public function isPerPage():
        bool;

    public function getName():
        string;

    public function getLabel():
        string;

    public function summarize(
        QueryBuilder $query,
        string $column
    ): mixed;

    public function summarizeRecords(
        array $records,
        string $column
    ): mixed;

    public function format(
        mixed $value
    ): string;

    public function toArray(
        mixed $value
    ): array;

    abstract public function aggregate():
        ?string;
}

Available summarizers:

text

Count
Sum
Average
Range

Summary Example

php

use PandaPanel\Tables\Summaries\Average;
use PandaPanel\Tables\Summaries\Range;
use PandaPanel\Tables\Summaries\Sum;

NumberColumn::make('total')
    ->decimals(2)
    ->summarize([
        Sum::make()
            ->label(
                'Total'
            ),

        Average::make()
            ->label(
                'Average'
            )
            ->formatUsing(
                fn (
                    mixed $value
                ): string =>
                    number_format(
                        (float) $value,
                        2
                    )
            ),

        Range::make()
            ->label(
                'Range'
            ),
    ]);

Summary Default Menggunakan Seluruh Filtered Query

Summary dihitung database terhadap filtered query.

Bukan dengan menjumlahkan hanya row pada page saat ini.

Contohnya:

text

Filtered records:
1.000

Per page:
25

Default Summary:

text

menghitung 1.000 record

bukan hanya:

text

25 row yang sedang terlihat

Jika Summary memang dimaksudkan hanya untuk page sekarang, gunakan:

php

->perPage()

Mengapa Default Bukan Page Total

Jika label:

text

Total

berubah hanya karena user menekan:

text

Next Page

maka angka yang sama memiliki arti berbeda.

Karena itu total default berasal dari keseluruhan filtered result.

`Group`

API:

php

public static function make(
    string $name
): self;

public function label(
    string $label
): self;

public function column(
    string $column
): self;
// default name

public function direction(
    SortDirection $direction
): self;
// Ascending

public function titleUsing(
    Closure $callback
): self;

public function descriptionUsing(
    Closure $callback
): self;

public function getName():
    string;

public function getLabel():
    string;

public function getColumn():
    string;

public function keyFor(
    Model $record
): string;

public function titleFor(
    Model $record
): string;

public function descriptionFor(
    Model $record
): ?string;

public function applySort(
    Builder $query
): void;

public function toArray():
    array;

Group Example

php

use PandaPanel\Tables\Group;

$table
    ->groups([
        Group::make('status')
            ->titleUsing(
                fn (
                    Model $record
                ): string =>
                    ucfirst(
                        (string)
                        $record->status
                    )
            ),

        Group::make('created_at')
            ->label(
                'Month'
            )
            ->direction(
                SortDirection::Descending
            ),
    ])
    ->defaultGroup(
        'status'
    );

Group Metadata Di-resolve di Server

Untuk setiap record server menentukan:

group key;
group title;
group description.

Frontend tidak perlu mengetahui bagaimana:

text

status = pending

diubah menjadi:

text

Pending Orders

Logic tersebut tetap berada di backend.

`Tab`

Tab merupakan filter tab yang berada di atas List Page.

Tab dideklarasikan melalui:

php

ListRecords::tabs()

API:

php

public static function make(
    string $key,
    ?string $label = null
): self;

public function query(
    Closure $callback
): self;
// Closure(Builder): Builder

public function badge(
    string|int|Closure|null $badge
): self;

public function icon(
    ?string $icon
): self;

public function getLabel():
    string;
// Str::headline($key)

public function apply(
    Builder $query
): Builder;

public function resolveBadge():
    string|int|null;

public function toArray(
    bool $active
): array;

public readonly string $key;

Tab Example

php

public function tabs(): array
{
    return [
        'all' =>
            Tab::make('all')
                ->badge(
                    fn (): int =>
                        User::query()
                            ->count()
                ),

        'admins' =>
            Tab::make(
                'admins',
                'Administrators'
            )
                ->icon(
                    'shield'
                )
                ->query(
                    fn (
                        Builder $query
                    ): Builder =>
                        $query->where(
                            'is_admin',
                            true
                        )
                ),
    ];
}

Tab Bukan Query Baru

Tab hanya merupakan named scope terhadap query Resource yang sudah ada.

Secara konsep:

text

Resource::query()
    ↓
Tenant Scope
    ↓
Permission Scope
    ↓
Tab::query()

Tab tidak memulai:

php

User::query()

sendiri.

Karena itu tenant dan permission scope tetap aktif.

`ArrayTableData`

ArrayTableData memungkinkan Table Schema yang sama digunakan terhadap data yang tidak berasal dari database.

Contohnya:

config file;
API response;
computed report;
in-memory collection.

API:

php

public static function make(
    TableSchema $schema,
    iterable $records,
    Request $request,
    ?string $namespace = null
): self;

public function paginate():
    LengthAwarePaginator;

public function state():
    array;

public function pagination(
    LengthAwarePaginator $records
): array;

public function rows(
    LengthAwarePaginator $records
): array;

public function sortableColumns():
    array;

ArrayTableData Example

php

use Illuminate\Http\Request;
use PandaPanel\Tables\ArrayTableData;
use PandaPanel\Tables\Columns\TextColumn;
use PandaPanel\Tables\TableSchema;

$schema =
    TableSchema::make()
        ->columns([
            TextColumn::make(
                'city'
            )
                ->searchable()
                ->sortable(),

            TextColumn::make(
                'temperature'
            )
                ->sortable(),
        ]);

$data =
    ArrayTableData::make(
        $schema,

        collect(
            $readings
        )
            ->map(
                fn (
                    array $row
                ) =>
                    Reading::make(
                        $row
                    )
            ),

        request(),
    );

$records =
    $data->paginate();

return Inertia::render(
    'Panels/Admin/Pages/Weather',
    [
        'table' =>
            $schema->toArray(),

        'state' =>
            $data->state(),

        'rows' =>
            $data->rows(
                $records
            ),

        'pagination' =>
            $data->pagination(
                $records
            ),
    ]
);

Search, Sort, dan Paging Dilakukan In-Memory

ArrayTableData tetap menggunakan deklarasi Column dari Table.

Perbedaannya hanya sumber row.

Pada Eloquent Table:

text

Resource::query()
→ database

Pada ArrayTableData:

text

iterable records
→ memory

Schema, serialization, dan row shape tetap sama.

Enums

Enum	Cases
`ColumnType`	`Text`, `Number`, `Badge`, `Boolean`, `Date`, `DateTime`, `Image`, `Icon`, `Color`, `Custom`, `Toggle`, `Checkbox`, `TextInput`, `Select`
`SortDirection`	`Ascending` (`asc`), `Descending` (`desc`); `fromRequest()`, `opposite()`
`Alignment`	`Start`, `Center`, `End`, `Justify`; `fromRequest()`
`BadgeColor`	`Neutral`, `Success`, `Warning`, `Danger`, `Info`; `fromValue()`
`ColumnPin`	`Start`, `End`
`FilterType`	`Select`, `Boolean`, `Date`, `Ternary`, `Form`, `QueryBuilder`
`ConstraintOperator`	empat belas case; memiliki `label()` dan `needsValue()`
`RecordActionsPosition`	`AfterColumns`, `BeforeColumns`, `AfterCells`
`RelationshipAggregate`	`Count`, `Exists`, `Sum`, `Avg`, `Min`, `Max`; `attributeFor()`, `apply()`

Mengapa `BadgeColor` dan `Alignment` Closed Set

Enum seperti:

php

BadgeColor
Alignment

dipetakan ke literal Tailwind class.

Compiler harus sudah melihat class tersebut ketika build.

Arbitrary runtime string dapat menghasilkan class yang tidak ada pada compiled CSS.

Jika yang Anda butuhkan adalah arbitrary color value, bukan semantic color, gunakan:

php

Panel::colors()

yang menghasilkan CSS custom property.

Endpoint yang Digunakan Table

Route Name	Digunakan oleh
`panel.{id}.actions.record`	Row Action
`panel.{id}.actions.bulk`	Bulk Action terhadap selection
`panel.{id}.actions.table`	Header, Toolbar, atau Empty-State Action
`panel.{id}.actions.reorder`	Drag reorder yang menulis ke Column dari `reorderable()`
`panel.{id}.actions.cell`	Write dari Editable Column
`panel.{id}.actions.form` / `actions.submit`	Action yang memiliki Form

Ringkasan Table State

URL dapat terlihat seperti:

text

/admin/users
?page=2
&perPage=25
&search=alan
&sort=created_at
&direction=desc
&filters[is_admin]=1

State tersebut dibaca oleh:

php

TableQuery

kemudian divalidasi terhadap:

php

TableSchema

sebelum diterapkan ke Builder.

Ringkasan Query Flow

text

Resource::query()
        ↓
TableQuery
        ↓
Column Queries
        ↓
Base Query Filters
        ↓
Global Search
        ↓
Column Searches
        ↓
Filters
        ↓
Sort
        ↓
Pagination
        ↓
Rows

TableQuery tidak menggantikan Resource query.

Ia hanya mempersempit query yang sudah diberikan.

Ringkasan Table Security Boundary

text

Query String
    ↓
TableSchema
    ↓
Validate:
- sort column
- search column
- filters
- group
- visible columns
- per page
    ↓
Sanitized State
    ↓
Builder

Client tidak dapat mengirim arbitrary database Column name lalu berharap framework meneruskannya langsung ke query.

Ringkasan Column Lifecycle

text

Model Record
    ↓
Column::resolveValue()
    ↓
formatUsing()
    ↓
Concrete Column formatting
    ↓
Cell Value
    ↓
Cell Metadata
    ↓
Vue Renderer

Ringkasan Editable Column

text

User mengubah cell
        ↓
POST actions.cell
        ↓
Resolve Resource
        ↓
Resolve Record
        ↓
Resolve Column dari Schema
        ↓
EditableColumn?
        ↓
Disabled untuk record?
        ↓
Authorize
        ↓
Validation Rules
        ↓
mutateUsing()
        ↓
updateUsing()
atau writeTo()
        ↓
Persist

Ringkasan Relationship Aggregate

text

Column
    ↓
counts / sum / avg / min / max
    ↓
applyColumnQueries()
    ↓
withCount / withSum / ...
    ↓
Single SQL query
    ↓
Generated aggregate attribute
    ↓
Column reads value

Tidak ada N+1 aggregate query per row.

Ringkasan Filters

text

URL
filters[status]=live
        ↓
Filter::sanitize()
        ↓
valid?
├── no
│   ↓
│   null / ignored
│
└── yes
    ↓
Filter::apply()
    ↓
Builder

Ringkasan FormFilter

text

FormFilter
├── from
└── until
    ↓
FormSchema
    ↓
Nested Filter State
    ↓
Filter query callback
    ↓
Builder

Satu logical Filter dapat memiliki beberapa form input.

Ringkasan QueryBuilderFilter

text

QueryBuilderFilter
    ↓
Constraints
├── TextConstraint
├── NumberConstraint
├── DateConstraint
└── BooleanConstraint
    ↓
Operator
    ↓
Value validation
    ↓
Builder

Ringkasan Summaries

Default:

text

Filtered Query
    ↓
Database Aggregate
    ↓
Summary

Dengan:

php

->perPage()

menjadi:

text

Current Page Records
    ↓
In-memory/Page Aggregate
    ↓
Summary

Ringkasan Groups

text

Query
    ↓
Group Sort
    ↓
Record
    ↓
Group::keyFor()
    ↓
Group::titleFor()
    ↓
Group::descriptionFor()
    ↓
Frontend Band

Ringkasan Tabs

text

Resource::query()
    ↓
Current Tab
    ↓
Tab::apply()
    ↓
TableQuery
    ↓
Search / Filter / Sort
    ↓
Pagination

Tab tidak mengganti Resource scope.

Ringkasan ArrayTableData

text

Iterable Records
        ↓
ArrayTableData
        ↓
Declared Table Columns
        ↓
In-memory Search
        ↓
In-memory Sort
        ↓
Pagination
        ↓
Table Rows
        ↓
Same Vue Renderer

Hal yang Perlu Diperhatikan

URL adalah State

Tidak ada state penting Table yang hanya hidup di local component state.

Hal ini memungkinkan:

text

filter
sort
search
page

direpresentasikan sebagai link yang dapat:

dibookmark;
dibagikan;
direfresh;
dinavigasi dengan Back/Forward.

Semua Query String Divalidasi terhadap Schema

Query string adalah user input.

Unknown:

text

sort
filter
group
column

tidak diteruskan langsung ke Builder.

Session Persistence Tetap Melalui Validation

State yang disimpan session tidak dianggap lebih terpercaya.

Jika session lama menyimpan:

text

sort = old_column

dan Column tersebut sudah dihapus dari schema, value tetap gagal whitelist dan tidak digunakan.

Table Dapat Berjalan Tanpa Session Middleware

Method:

php

persist*InSession()

menjadi no-op jika session tidak tersedia.

Bukan fatal error.

Dengan begitu schema yang sama dapat dipakai dari context seperti:

console command;
non-session environment.

`bulkActions()` Otomatis Mengaktifkan Selection

Mendeklarasikan Bulk Action tetapi lupa:

php

selectable()

tidak menyebabkan Table unusable.

Schema mengaktifkannya secara otomatis.

Aggregate Ditambahkan ke Query

Method seperti:

php

counts()
sum()
avg()

menggunakan aggregate query seperti:

php

withCount()
withSum()

bukan menjalankan query satu per row.

`reorderable()` juga Mengatur Default Sort

Jika:

php

->reorderable('position')

digunakan, default sort menjadi:

text

position ASC

Agar visual order sama dengan order yang memang dapat diubah user melalui drag.

Prinsip Utama Tables

PandaBear memperlakukan Table bukan hanya sebagai renderer row, tetapi sebagai server-defined query contract.

TableSchema menentukan:

text

Column mana yang ada
Column mana yang searchable
Column mana yang sortable
Filter mana yang valid
Group mana yang valid
Action mana yang valid
Column mana yang dapat diedit
State mana yang boleh diterima

Sedangkan TableQuery menerima user-controlled URL state dan hanya menerapkan bagian yang lolos schema whitelist.

Secara singkat:

URL menyimpan state Table, tetapi Table Schema menentukan bagian mana dari state tersebut yang valid dan boleh memengaruhi query.

Prinsip berikutnya:

TableQuery tidak pernah memulai query sendiri. Ia selalu mempersempit Resource query yang sudah membawa tenant, parent, module, dan permission scope.

Dengan desain ini, fitur:

text

search
sort
filters
groups
pagination
column manager
actions
editable cells

tetap berada dalam boundary Resource dan Schema yang sama.

Referensi Tables ​

Namespaces ​

Contoh Table yang Berfungsi ​

TableSchema ​

Content ​

Duplicate Column dan Filter ​

Sorting, Searching, dan Paging ​

splitSearchTerms() ​

Unknown Default Sort ​

Persistence dan Deferral ​

Request Selalu Mengalahkan Session ​

Filter Bar dan Column Manager ​

Rows, Selection, dan Actions ​

Action Validation ​

bulkActions() Mengaktifkan Selection ​

Reorderable Table ​

Empty State ​

Membaca Schema ​

Action Lookup adalah Whitelist ​

Menghasilkan Payload ​

toRow() ​

TableQuery ​

Contoh TableQuery ​

Urutan Constraint ​

paginate() ​

TableQuery Tidak Memulai Query ​

Query Parameters ​

Query String adalah User Input ​

state() ​

Namespaces ​

Mengapa Namespace Diperlukan ​

Column ​

Identity dan Behaviour ​

searchable() ​

Presentation ​

width() ​

Frozen Columns ​

Links, Actions, dan Summaries ​

Reading Column ​

Column Types ​

Contoh Column ​

Custom Column Component ​

EditableColumn ​

EditableColumn API ​

Editable Column Examples ​

HasRelationshipState ​

Aggregate Examples ​

Aggregate Tidak Melakukan Query per Row ​

RelationshipAggregate ​

Filters ​

sanitize() adalah Whitelist ​

Filter Types ​

Filter Examples ​

FormFilter ​

Query Builder Constraints ​

QueryBuilderFilter Example ​

ConstraintOperator ​

Summaries ​

Summary Example ​

Summary Default Menggunakan Seluruh Filtered Query ​

Mengapa Default Bukan Page Total ​

Group ​

Group Example ​

Group Metadata Di-resolve di Server ​

Tab ​

Tab Example ​

Tab Bukan Query Baru ​

ArrayTableData ​

ArrayTableData Example ​

Search, Sort, dan Paging Dilakukan In-Memory ​

Enums ​

Mengapa BadgeColor dan Alignment Closed Set ​

Endpoint yang Digunakan Table ​

Ringkasan Table State ​

Ringkasan Query Flow ​

Ringkasan Table Security Boundary ​

Ringkasan Column Lifecycle ​

Ringkasan Editable Column ​

Ringkasan Relationship Aggregate ​

Ringkasan Filters ​

Referensi Tables

Namespaces

Contoh Table yang Berfungsi

`TableSchema`

Content

Duplicate Column dan Filter

Sorting, Searching, dan Paging

`splitSearchTerms()`

Unknown Default Sort

Persistence dan Deferral

Request Selalu Mengalahkan Session

Filter Bar dan Column Manager

Rows, Selection, dan Actions

Action Validation

`bulkActions()` Mengaktifkan Selection

Reorderable Table

Empty State

Membaca Schema

Action Lookup adalah Whitelist

Menghasilkan Payload

`toRow()`

`TableQuery`

Contoh `TableQuery`

Urutan Constraint

`paginate()`

TableQuery Tidak Memulai Query

Query Parameters

Query String adalah User Input

`state()`

Namespaces

Mengapa Namespace Diperlukan

`Column`

Identity dan Behaviour

`searchable()`

Presentation

`width()`

Frozen Columns

Links, Actions, dan Summaries

Reading Column

Column Types

Contoh Column

Custom Column Component

`EditableColumn`

EditableColumn API

Editable Column Examples

`HasRelationshipState`

Aggregate Examples

Aggregate Tidak Melakukan Query per Row

`RelationshipAggregate`

Filters

`sanitize()` adalah Whitelist

Filter Types

Filter Examples

`FormFilter`

Query Builder Constraints

QueryBuilderFilter Example

`ConstraintOperator`

Summaries

Summary Example

Summary Default Menggunakan Seluruh Filtered Query

Mengapa Default Bukan Page Total

`Group`

Group Example

Group Metadata Di-resolve di Server

`Tab`

Tab Example

Tab Bukan Query Baru

`ArrayTableData`

ArrayTableData Example

Search, Sort, dan Paging Dilakukan In-Memory

Enums

Mengapa `BadgeColor` dan `Alignment` Closed Set

Endpoint yang Digunakan Table

Ringkasan Table State

Ringkasan Query Flow

Ringkasan Table Security Boundary

Ringkasan Column Lifecycle

Ringkasan Editable Column

Ringkasan Relationship Aggregate

Ringkasan Filters