Skip to content
Advertisement

How to insert SUM() function that sums rows with similar ID in a code part of witch is unchangeable?

I am trying to write a quarry in a module for Dolibarr ERP. But module hase a part of code that is predefined and can not be changed. And I need to insert a SUM() function in it that will combine rows with similar id. That i know how to do in a regular MySQL:

that gives me what I want :

BUT module has a predefined unchangeable code :

this part is predefined module writes it himself based on values provider in it:

THIS PART I CAN WRITE IN A MODULES GUI:

And this part is predefined:

I would appreciate any help and advice on question is there any workaround that can be done to make my desired and result ampere ? As it would using the first code I posted ?

Advertisement

Answer

If you can only modify the bit in the middle box then you might need to use a subquery;

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement