Hi, i have an grid app with a report working hours. I need to show the TOTAL for fields. How can i do the summation?
Hello Alvagar
I would think that in scriptcase it is not possible.
There is a possibility
Can you add to the final select
group by field with rollup
Example
mysql> select product,order_date,sum(sale)
from sales group by product,order_date with rollup;
±--------±-----------±----------+
| product | order_date | sum(sale) |
±--------±-----------±----------+
| A | 2020-01-01 | 20 |
| A | 2020-01-04 | 30 |
| A | 2020-01-05 | 20 |
| A | NULL | 70 |
| B | 2020-01-02 | 25 |
| B | 2020-01-03 | 15 |
| B | NULL | 40 |
| NULL | NULL | 110 |
±--------±-----------±----------+
Hi, gegar500.
Thanks you for your response.
I think it is good option for execute sql directily from dbms
But I need show the result directly from SC report.
I Hope SC TEAM add it new functionality.
Hi, Thank you for you interest in my question.
I need to know how you sum the time field from SC?. your sql query is same you posted?
I hope help to you.
Yes it’s the same