Feature Guide

A quick orientation block that answers the essential questions: what this feature does, how it works, why it matters, and the key concepts behind it.

What this does

Mark a property #[Filterable] and the ORM handles the rest — no manual WHERE clauses.

Filter Criteria

Live filtered result set

No filters applied — showing the broad demo dataset.

10 Matched products

0 Active filters

Name	Price	Status
Air Purifier	$149.99	active
Domain-Driven Design	$54.99	active
Ergonomic Chair	$299.99	active
Foam Roller	$29.99	active
Head First Design Patterns	$49.99	active
Linen Shirt	$54.99	active

#[Filterable] FilterableTrait FilterableResourceInterface getFilterCriteria()

Verified against Semitexa Ultimate 2026.09.19.1020

Filtering

The #[Filterable] attribute on a ResourceModel property registers that column as a valid filter target. The ORM builds the WHERE clause automatically from the declared filter criteria.

How it works

A resource implements FilterableResourceInterface and uses FilterableTrait. Marking a property #[Filterable] makes that column available to getFilterCriteria(). Repositories pass the criteria to the query builder, which compiles the WHERE clause without manual string construction. Handlers simply pass payload values through to the repository.

Why this matters

Manual WHERE clause construction per property is repetitive and error-prone. A single attribute declaration keeps filter capability co-located with the column definition, and the ORM ensures that only declared filterable columns can appear in generated queries.

1<?php23declare(strict_types=1);45namespace App\Application\Db\Model;67use Semitexa\Orm\Attributes\Column;8use Semitexa\Orm\Attributes\FromTable;910#[FromTable(name: 'products')]11final class ProductResource12{13    #[Column(type: 'uuid')]14    public string $id;1516    #[Column(type: 'varchar', length: 255)]17    public string $name;1819    #[Column(type: 'decimal', precision: 10, scale: 2)]20    public string $price;2122    #[Column(type: 'varchar', length: 32)]23    public string $status;24}25

<?php

declare(strict_types=1);

namespace App\Application\Db\Model;

use Semitexa\Orm\Attributes\Column;
use Semitexa\Orm\Attributes\FromTable;

#[FromTable(name: 'products')]
final class ProductResource
{
    #[Column(type: 'uuid')]
    public string $id;

    #[Column(type: 'varchar', length: 255)]
    public string $name;

    #[Column(type: 'decimal', precision: 10, scale: 2)]
    public string $price;

    #[Column(type: 'varchar', length: 32)]
    public string $status;
}

1<?php23declare(strict_types=1);45namespace App\Application\Handler\Data;67use App\Application\Payload\Data\ProductCatalogPayload;8use App\Application\Resource\Page\ProductCatalogResource;9use App\Domain\Catalog\ProductReadRepositoryInterface;10use Semitexa\Core\Attribute\AsPayloadHandler;11use Semitexa\Core\Attribute\InjectAsReadonly;12use Semitexa\Core\Contract\TypedHandlerInterface;1314#[AsPayloadHandler(payload: ProductCatalogPayload::class, resource: ProductCatalogResource::class)]15final class ProductCatalogHandler implements TypedHandlerInterface16{17    #[InjectAsReadonly]18    protected ProductReadRepositoryInterface $products;1920    public function handle(ProductCatalogPayload $payload, ProductCatalogResource $resource): ProductCatalogResource21    {22        return $resource->fromProducts($this->products->findForCatalog($payload));23    }24}25

<?php

declare(strict_types=1);

namespace App\Application\Handler\Data;

use App\Application\Payload\Data\ProductCatalogPayload;
use App\Application\Resource\Page\ProductCatalogResource;
use App\Domain\Catalog\ProductReadRepositoryInterface;
use Semitexa\Core\Attribute\AsPayloadHandler;
use Semitexa\Core\Attribute\InjectAsReadonly;
use Semitexa\Core\Contract\TypedHandlerInterface;

#[AsPayloadHandler(payload: ProductCatalogPayload::class, resource: ProductCatalogResource::class)]
final class ProductCatalogHandler implements TypedHandlerInterface
{
    #[InjectAsReadonly]
    protected ProductReadRepositoryInterface $products;

    public function handle(ProductCatalogPayload $payload, ProductCatalogResource $resource): ProductCatalogResource
    {
        return $resource->fromProducts($this->products->findForCatalog($payload));
    }
}