UCCX 8: Sum values using DB Read/Get

[lohjintiam]

Hi all,

Appreciate your advice on how best to tackle this

a) My table structure is something like this

Staff ID	Description	Value
0001	Salary 1	100
0001	Salary 2	200
0002	Salary 1	300
0002	Salary 2	400
0002	Claim 1	-100

b) Using both DB Read/Get, am i able to sum up all values pertaining to Staff 0001?

c) Or do i need to extract all rows pertaining to Staff 0001 and calculate those value outside of the DB functions?

Thanks!

-JT-