staudenmeir / eloquent-eager-limit-x-laravel-adjacency-list Goto Github PK

Code:

use HasEagerLimitAndRecursiveRelationships;

    public function getPivotTableName(): string
    {
        return 'calculated_kpis';
    }

    public function getParentKeyName(): string
    {
        return 'from_kpi_id';
    }

    public function getChildKeyName(): string
    {
        return 'for_kpi_id';
    }

Command:
Kpi::find(2557)->ancestors

Error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'laravel_cte.from_kpi_id' in 'on clause' (Connection: mysql, SQL: with recursive `laravel_cte` as ((select *, -1 as `depth`, cast(`id` as char(65535)) as `path` from `kpis` where `kpis`.`id` is null) union all (select `kpis`.*, `depth` - 1 as `depth`, concat(`path`, ., `kpis`.`id`) from `kpis` inner join `laravel_cte` on `laravel_cte`.`from_kpi_id` = `kpis`.`id`)) select * from `laravel_cte` where `laravel_cte`.`deleted_at` is null).

When using only laravel-adjacency-list works fine.