Sum and Group By in server action

DecoresinSrl · February 9, 2019, 7:18am

I have this query:

but I don’t show SUM

I want show SUM of “Codice Articolo”

Teodor · February 9, 2019, 7:37am

Please provide a link to your page.

DecoresinSrl · February 9, 2019, 7:39am

this is a test page

Teodor · February 9, 2019, 8:39am

Please add an alias for the SUM column and use it in the table generator then

DecoresinSrl · February 9, 2019, 8:50am

ok, it works
but it doesn’t order DESC

nshkrsh · February 11, 2019, 2:10pm

Sorting is not working because the column you need to sort by is totale_articolo.
Which is not accessible here in query builder.

Remove the sorting condition from query builder, and just add the column alias name in Server Connect’s sort property as below:

DecoresinSrl · February 11, 2019, 4:59pm

ok, I did as you say but does not work

nshkrsh · February 12, 2019, 2:18am

I did the same and it worked for me.
See here: http://wappler.slashash.co/test/sortalias.php

Can you share a link of your page?

DecoresinSrl · February 12, 2019, 6:59am

nshkrsh · February 12, 2019, 8:57am

Two observations:

There is no KEY set for the repeat expression.
totale_articolo is returned as numeric, whereas in my test url, the SUM column sumal is being returned as a string. Don’t exactly know why - probably has something to do with MySQL version.
You can see this too in the Network tab response JSON of Chrome’s dev tools.
My DB has this column as int(11). And prepared statements in my DB connection is TRUE. MariaDB 10.2.21.