Question

I'm trying to query the total elapsed hours (i.e., This Case + ALL subcases) via the API and I don't see a way to do it. The query I'm currently using is:

cmd=search&q=Project:=128&cols=sTitle,sPersonAssignedTo,dtDue,hrsElapsed

The hrsElapsed column gets me the hours on that specific cases, but not the hours on any subcases. The UI provides a nice view of this number I'm looking for, and I can get it in a spreadsheet via the 'Export to Excel' action, but I'd like to programmatically query this value so I can automatically update project reports.

Is this possible?

THANKS!

Case FC1874578

Answer 1

There isn't currently a column option to get the hrsElapsed including all children. I have opened a case to consider adding this functionality in a future version. Please up-vote the question to show your support for this feature.

As a workaround, you can include ixBugChildren in the cols list and walk down the hierarchy getting the times. In any case, you will want to make sure you don't double-count when your search returns the parent case(s) and the subcases.