Sum of dedicated time of a tracker type in the project

Question

Sum of dedicated time of a tracker type in the project

mavag opened this issue 7 years ago · 5 comments

Hello, on ticket # 64 I have seen how to add all the dedicated hours of project tickets, but this is for all types of tickets:

time_entries.sum (: hours) .round (2)

Is there a way to do it with only one type of ticket?

Many thanks for the help

mavag commented 7 years ago

Tracker

Answer 1 · 2017-09-18T04:52:53.000Z

Hi. What is a type of ticket?

Answer 2 · 2017-09-22T09:14:38.000Z

time_entries.includes(:issue).where(issues: { tracker_id: YOUR_TRACKER_ID }).sum(:hours).round(2)

Answer 3 · 2017-09-22T13:01:20.000Z

Ouuuuuyeaaaa!! Thanks!!!

Answer 4 · 2017-09-26T13:56:57.000Z

Extensive information for the result to be in time format:

hours = time_entries.includes(:issue).where(issues:{YOUR_TRACKER_ID}).sum(:hours).round(2)
hours_part = hours.truncate
minutes = ((hours - hours_part) * 60).round
result = hours_part.to_s + ":" + minutes.to_s