Table Summarizer Bug on PostgreSQL

So I have a table column defined as such:

Tables\Columns\TextColumn::make('price')
        ->money()
        // Old simple way
    // ->summarize(Sum::make()->money()->label('Total Price')),
    // New Way with custom query
    ->summarize(
        Summarizer::make()
            ->label('Total')
            ->money()
            ->using(fn (\Illuminate\Database\Query\Builder $query) => $query->sum(DB::raw('price * quantity'))),

Tables\Columns\TextColumn::make('price')
        ->money()
        // Old simple way
    // ->summarize(Sum::make()->money()->label('Total Price')),
    // New Way with custom query
    ->summarize(
        Summarizer::make()
            ->label('Total')
            ->money()
            ->using(fn (\Illuminate\Database\Query\Builder $query) => $query->sum(DB::raw('price * quantity'))),

I had asked yesterday how do to this price * quantity calculation but I was getting this error:

SQLSTATE[42601]: Syntax error: 7 ERROR: zero-length delimited identifier at or near """"

SQLSTATE[42601]: Syntax error: 7 ERROR: zero-length delimited identifier at or near """"

The query that is generated is

SELECT
  sum(price * quantity) AS aggregate
FROM
  (
    SELECT
      "line_items".*
    FROM
      "line_items"
      INNER JOIN "invoices" ON "invoices"."id" = "line_items"."invoice_id"
    WHERE
      "invoices"."requisition_id" = 1
  ) AS ""

SELECT
  sum(price * quantity) AS aggregate
FROM
  (
    SELECT
      "line_items".*
    FROM
      "line_items"
      INNER JOIN "invoices" ON "invoices"."id" = "line_items"."invoice_id"
    WHERE
      "invoices"."requisition_id" = 1
  ) AS ""

Clearly it's the last line

) AS ""

) AS ""

. I dug into the

Summarizer.php

Summarizer.php

file on line 108.

$query = DB::table($query->toBase());

$query = DB::table($query->toBase());

I haven't really looked at the source code for any of the Filament query stuff before it I changed the line to

$query = DB::table($query->toBase(), 'test');

$query = DB::table($query->toBase(), 'test');

The above code now works. I'm not saying the table alias needs to be 'test' but I just needed a name to try. I'm not really sure what the best practice (naming) for this would be but I might also cross post this as a GitHub issue.

Just wasn't sure if there was something else on the 'user' side (me, the dev) that I need to do to get this working? (since it also seems like a postgres quirk)

Filament•3y ago•

35 replies

Shavik

Table Summarizer Bug on PostgreSQL

So I have a table column defined as such:

Tables\Columns\TextColumn::make('price')
        ->money()
        // Old simple way
    // ->summarize(Sum::make()->money()->label('Total Price')),
    // New Way with custom query
    ->summarize(
        Summarizer::make()
            ->label('Total')
            ->money()
            ->using(fn (\Illuminate\Database\Query\Builder $query) => $query->sum(DB::raw('price * quantity'))),

Tables\Columns\TextColumn::make('price')
        ->money()
        // Old simple way
    // ->summarize(Sum::make()->money()->label('Total Price')),
    // New Way with custom query
    ->summarize(
        Summarizer::make()
            ->label('Total')
            ->money()
            ->using(fn (\Illuminate\Database\Query\Builder $query) => $query->sum(DB::raw('price * quantity'))),

I had asked yesterday how do to this price * quantity calculation but I was getting this error:

SQLSTATE[42601]: Syntax error: 7 ERROR: zero-length delimited identifier at or near """"

SQLSTATE[42601]: Syntax error: 7 ERROR: zero-length delimited identifier at or near """"

The query that is generated is

SELECT
  sum(price * quantity) AS aggregate
FROM
  (
    SELECT
      "line_items".*
    FROM
      "line_items"
      INNER JOIN "invoices" ON "invoices"."id" = "line_items"."invoice_id"
    WHERE
      "invoices"."requisition_id" = 1
  ) AS ""

SELECT
  sum(price * quantity) AS aggregate
FROM
  (
    SELECT
      "line_items".*
    FROM
      "line_items"
      INNER JOIN "invoices" ON "invoices"."id" = "line_items"."invoice_id"
    WHERE
      "invoices"."requisition_id" = 1
  ) AS ""

Clearly it's the last line

) AS ""

) AS ""

. I dug into the

Summarizer.php

Summarizer.php

file on line 108.

$query = DB::table($query->toBase());

$query = DB::table($query->toBase());

I haven't really looked at the source code for any of the Filament query stuff before it I changed the line to

$query = DB::table($query->toBase(), 'test');

$query = DB::table($query->toBase(), 'test');

Table Summarizer Bug on PostgreSQL

Similar Threads

Table Summarizer Bug on PostgreSQL

Similar Threads

Similar Threads

Similar Threads