Making a sum with Query Result

RT Developers
1

Hello There!!!

I’ve been trying to make a query that does the sum of a custom field but i’m litle bit lost… For example, there are 2 tickets and in a custom field called “time allocated” I have 10 and 20 values respectively. So, when execute a query (by the owner, for example) shows 30 as final result.

Is it possible? How?

Thank’s in advance!!!

Rodolfo de Moraes Reis
DSIN - Grupo de Teste e Qualidade
CPqD Telecom & IT Solutions
Tel.: +55 19 3705-5986
Fax: +55 19 3705-6786
rmreis@cpqd.com.br
www.cpqd.com.br

2

Hello There!!!

I’ve been trying to make a query that does the sum of a custom field but i’m
litle bit lost… For example, there are 2 tickets and in a custom field
called “time allocated” I have 10 and 20 values respectively. So, when
execute a query (by the owner, for example) shows 30 as final result.

Is it possible? How?

Not possible. But you could create a much smaller version of my
RT3StatisticsPackageTimeWorked plugin.

http://wiki.bestpractical.com/admin/index.cgi?RT3StatisticsPackageTimeWorked

Andy Harrison

3

Hello There!!!

I’ve been trying to make a query that does the sum of a custom field but i’m litle bit lost… For example, there are 2 tickets and in a custom field called “time allocated” I have 10 and 20 values respectively. So, when execute a query (by the owner, for example) shows 30 as final result.

Is it possible?? How???

Thank’s in advance!!!

Rodolfo de Moraes Reis
DSIN - Grupo de Teste e Qualidade
CPqD Telecom & IT Solutions
Tel.: +55 19 3705-5986
Fax: +55 19 3705-6786
rmreis@cpqd.com.br
www.cpqd.com.br