ORA-00918: column ambiguously

[danielhxc]

Problem:

When using bulk actions, selecting the checkbox for all rows does not check the rows and I get the error "ORA-00918: column ambiguously defined"

Cod

`` protected $model = Novedad::class;

public function columns(): array
{
    return [
        Column::make("Id", "id"),
        Column::make("Fecha", "fecha")
            ->sortable()
            ->format(function($value){
                return $value->format("d/m/Y");
            })
            ->excludeFromColumnSelect(),
        Column::make("Nombres", "nombres")
            ->sortable()
            ->searchable(
                function(Builder $query, $searchTerm) {
                    $query->orWhere('nombres', 'like', '%'.strtoupper($searchTerm).'%');
                }
            ),
        Column::make("Ent. mat", "entrada_matutina"),
        Column::make("Sal. mat", "salida_matutina"),
        Column::make("Ent. ves", "entrada_vespertina"),
        Column::make("Sal. ves", "salida_vespertina"),
        Column::make("Atrasos", "atrasos")
            ->sortable(),
        Column::make("Horario", "horario")
            ->sortable(),
        Column::make("Observaciones", "observaciones")
    ];
}

``

The generated query is as follows:

select t2.* from ( select rownum AS "rn", t1.* from ( select "SCRH"."NOVEDADES"."ID" as "ID", "SCRH"."NOVEDADES"."FECHA" as "FECHA", "SCRH"."NOVEDADES"."NOMBRES" as "NOMBRES", "SCRH"."NOVEDADES"."ENTRADA_MATUTINA" as "ENTRADA_MATUTINA", "SCRH"."NOVEDADES"."SALIDA_MATUTINA" as "SALIDA_MATUTINA", "SCRH"."NOVEDADES"."ENTRADA_VESPERTINA" as "ENTRADA_VESPERTINA", "SCRH"."NOVEDADES"."SALIDA_VESPERTINA" as "SALIDA_VESPERTINA", "SCRH"."NOVEDADES"."ATRASOS" as "ATRASOS", "SCRH"."NOVEDADES"."HORARIO" as "HORARIO", "SCRH"."NOVEDADES"."OBSERVACIONES" as "OBSERVACIONES", "SCRH"."NOVEDADES"."ID" as "ID", "SCRH"."NOVEDADES"."FECHA" as "FECHA", "SCRH"."NOVEDADES"."NOMBRES" as "NOMBRES", "SCRH"."NOVEDADES"."ENTRADA_MATUTINA" as "ENTRADA_MATUTINA", "SCRH"."NOVEDADES"."SALIDA_MATUTINA" as "SALIDA_MATUTINA", "SCRH"."NOVEDADES"."ENTRADA_VESPERTINA" as "ENTRADA_VESPERTINA", "SCRH"."NOVEDADES"."SALIDA_VESPERTINA" as "SALIDA_VESPERTINA", "SCRH"."NOVEDADES"."ATRASOS" as "ATRASOS", "SCRH"."NOVEDADES"."HORARIO" as "HORARIO", "SCRH"."NOVEDADES"."OBSERVACIONES" as "OBSERVACIONES", "SCRH"."NOVEDADES"."ID" as "ID", "SCRH"."NOVEDADES"."FECHA" as "FECHA", "SCRH"."NOVEDADES"."NOMBRES" as "NOMBRES", "SCRH"."NOVEDADES"."ENTRADA_MATUTINA" as "ENTRADA_MATUTINA", "SCRH"."NOVEDADES"."SALIDA_MATUTINA" as "SALIDA_MATUTINA", "SCRH"."NOVEDADES"."ENTRADA_VESPERTINA" as "ENTRADA_VESPERTINA", "SCRH"."NOVEDADES"."SALIDA_VESPERTINA" as "SALIDA_VESPERTINA", "SCRH"."NOVEDADES"."ATRASOS" as "ATRASOS", "SCRH"."NOVEDADES"."HORARIO" as "HORARIO", "SCRH"."NOVEDADES"."OBSERVACIONES" as "OBSERVACIONES" from "SCRH"."NOVEDADES") t1 ) t2 where t2."rn" between 1 and 10

In the query generated the columns are triplicate

Package

• Laravel 8
• php 7.4
• yajra/laravel-"oci8"
• rappasoft/laravel-livewire-tables: "2.7"