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...](https://images-ext-2.discordapp.net/external/7lesHV5TJfXV9rDct_prZ0T8dzM8AdALoVfer2-rnhs/https/github.githubassets.com/assets/gist-og-image-54fd7dc0713e.png)
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...
