Getting Error in Query Builder in Table Widget
https://gist.github.com/abhi051002/cdbee5da66029f4ada377f3df40cceaa
when i use a query in table widget it gives me the error " SQLSTATE[42803]: Grouping error: 7 ERROR: column "payments.id" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...ONTH FROM transaction_date) order by "month" asc, "payments"... ^" but when i use the same query any where and dd/info the result it works well why it is not working on query builder and give the erro and i know if i add the payments.id then it will work well but i want result without including it.
Gist
Getting the error "SQLSTATE[42803]: Grouping error: 7 ERROR: column...
Getting the error "SQLSTATE[42803]: Grouping error: 7 ERROR: column "payments.id" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...ONTH F...
10 Replies
Please dont spam the system with multiple same questions.
i need the answer thats why i'm doing this
config/database.php set your Strict to false, see if that helps
@hello_world
if its on strict you must specify a select for everything that is in a groupby
no that didn't help
mm
could you add this to the query?
and strictly this has nothing to do with laravel filament
no this isn't working just want to mention that i'm using postgresql
ooh
sorry i have no experience with that type of database sorry
okay no worry thanks for the help