[rt-users] Calculations on custom field values

[Thomas Smith]

I am interested in this as well as my company is in a similar
situation--this capability would determine whether or not we used RT
for tracking information that requires these types of calculations.

Can anyone offer a hint as to whether or not this is possible to do?
Even if it's a custom extension? We may be interesting in paying for
someone to write that?

On Tue, Mar 1, 2011 at 4:44 PM, Daniel Farst <daniel.farst at case.edu> wrote:
> I have a couple of things I'd like to do with RT and haven't been able to find any clear answers how to do it, or if it's even possible. Can anyone point me in the right direction? We'd like to do some simple calculations on values stored in a custom fields and on values from those custom fields in tickets returned from a saved search.
>
> Some background info: We use a queue in RT 3.8.8 to keep track of upcoming orders we need to place with a ticket for each order. Those tickets have custom fields tracking several values including order cost, what we're charging for the order, order status, tracking numbers, etc..
>
> I'm pretty sure I can accomplish this first part using scrips on a ticket update, but would like confirmation. I'd like to have certain values in a custom field calculated and updated when a different custom field value is changed. i.e. I update the order total and the field holding what we're charging for the order is automatically recalculated and updated as well.
>
> The second part I'm not sure about. I'd like to be able to have RT give me the result of a calculation of the values in a custom field for the tickets returned by a saved search (e.g. average value of the cost of orders from user 'abc', sum of the cost of orders where custom field Order_Status = Shipped, etc.). Is this doable by RT? Is there an extension that does this that I would need to install?
>
> Thanks!
>
> --
> Daniel Farst
> IT Support Coordinator
> College of Arts and Sciences
> Case Western Reserve University
>
> daniel.farst at case.edu
>
> Public key on keyserver.pgp.com



-- 
Thomas Smith
Cell: 602-882-2917