Ambiguous Column on created_at

[akulmehta]

Livewire PowerGrid version

v6.3.1

Livewire version

latest

Laravel version

latest

Which PHP version are you using?

PHP 8.4

Which Theme are you using?

Tailwind

Have you published the resource files and customized them? (php artisan vendor:publish)

No

What is the problem?

I am not sure if this is related to issue #1884 (comment), but I am getting an ambiguous column error on Postgres on the created_at column when I am trying to filter by the created_at using the datepicker.

For example, I have an activity log table for users:

Here is the error:

SQLSTATE: Ambiguous column: 7 ERROR:  column reference "created_at" is ambiguous
LINE 1: ...ere "causer_type" = $1 and "causer_id" = $2 and (("created_a...
                                                             ^ (Connection: pgsql, SQL: select count(*) as aggregate from "activity_log" inner join "users" on "activity_log"."causer_id" = "users"."id" where "causer_type" = App\Models\User and "causer_id" = 8 and (("created_at" between 2025-04-08 and 2025-04-15))) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: 42702): SQLSTATE: Ambiguous column: 7 ERROR:  column reference \"created_at\" is ambiguous
LINE 1: ...ere \"causer_type\" = $1 and \"causer_id\" = $2 and ((\"created_a...
                                                             ^ (Connection: pgsql, SQL: select count(*) as aggregate from \"activity_log\" inner join \"users\" on \"activity_log\".\"causer_id\" = \"users\".\"id\" where \"causer_type\" = App\\Models\\User and \"causer_id\" = 8 and ((\"created_at\" between 2025-04-08 and 2025-04-15))) at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:822)

I have also noticed this on all of my other tables.

Code snippets

    public function datasource(): Builder
    {
        return Activity::where('subject_type', 'App\Models\\' . $this->model)
            ->where('subject_id', $this->modelID)
            ->with(['subject' => fn($q) => $q->withTrashed(), 'causer'])
            ->join('users', 'activity_log.causer_id', '=', 'users.id')
            ->select('activity_log.*', 'users.name as user_name');
    }

    public function columns(): array
    {
        return [

            Column::action('Action')
                ->bodyAttribute('min-w-28 max-w-28 text-wrap'),

            Column::make('ID', 'id')
                ->searchable()
                ->sortable()
                ->hidden(isHidden: true, isForceHidden: false),

            Column::make('At', 'created_at_formatted', 'created_at')
                ->bodyAttribute('min-w-28 max-w-28 text-wrap')
                ->searchable()
                ->sortable(),

            Column::make('By', 'user_name')
                ->searchable()
                ->sortable(),

            Column::make('Subject', 'subject')
                ->bodyAttribute('min-w-48 max-w-48 text-wrap'),

            Column::make('Description', 'description')
                ->bodyAttribute('max-w-48 text-wrap')
                ->searchable()
                ->sortable(),

            // Column::make('Created at', 'created_at')
            //     ->hidden(),

        ];
    }

    public function filters(): array
    {
        return [
            Filter::inputText('description'),
            Filter::datepicker('created_at_formatted', 'created_at'), // FIXME: this is not working - giving sql error.
        ];
    }

How do you expect it to work?

Should not give the SQL error.

Please confirm (incomplete submissions will not be addressed)

• I have provided easy and step-by-step instructions to reproduce the bug.
• I have provided code samples as text and NOT images.
• I understand my bug report will be removed if I haven't met the criteria above.

[akulmehta]

@luanfreitasdev are you able to reproduce this?