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.
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 "payments.id" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...ONTH F...
