Ticket's Total resolution time

[efacsyc]

Hi!!!

Sorry for my English disastrous.

Is there any option from system configuration to do what executes the sentence:

• SELECT `ticket_id`, min(`create_time`) as begin, max(`create_time`) as end, sec_to_time(unix_timestamp(max(`create_time`))-unix_timestamp(min(`create_time`))) as duration FROM `article` group by `ticket_id`;

duration = create_time last article - create_time first article

Later, I want to introduce duration into a "dynamic field" "Duration", how could be made, how could run the SELECT to display the value?
Or is there another way to display this content?

Field "Age" doesn't help me.

Thanks.

Bye