Hi Brad, You are correct: for straight up aggregate functions, using a single report call can efficiently achieve the same thing as multiple search calls. I've just run a report test that is similar what you're trying to do, which I invite you to study so you can then build something similar that meets your needs. In it, I requested all of the hours entered by an owner whose name contains "Michael" (to keep the data set small) from time sheets with a particular end date (as you're doing), grouped first by owner name (as you're doing), grouped second by project name (similar to what you're doing with company, but as such companies are null in my test data), summing the hours , with a grand total for good measure. Here's what that looks like in the url (once you've logged in to YOURDOMAIN):
https://YOURDOMAIN.my.workfront.com/attask/api/v10.0/ hour / report ? owner:name=Michael&owner:name_Mod=contains & timesheet:endDate=2018-10-15×heet:endDate_Mod=eq &fields= owner:name , project:name , hours & owner:name_1_GroupBy=true & project:name_2_GroupBy=true & hours_AggFunc=sum & $$ROLLUP=true I've also pasted the (obfuscated) results below, for reference. Regards, Doug [DDH: corrected to refer to project:name, vs project:portfolio:name] {
data :
{
Michael 1 :
{
Project A :
{
dcount_ID : 1 ,
sum_hours : 1 ,
owner_name : "Michael 1" ,
project_name : "Project A"
},
Project B :
{
dcount_ID : 1 ,
sum_hours : 3 ,
owner_name : "Michael 1" ,
project_name : "Project B"
},
:
{
dcount_ID : 5 ,
sum_hours : 40 ,
owner_name : "Michael 1" ,
project_name : null
},
$$ROLLUP :
{
dcount_ID : 7 ,
sum_hours : 44
}
},
Michael 2 :
{
Project B :
{
dcount_ID : 2 ,
sum_hours : 2 ,
owner_name : "Michael 2" ,
project_name : "Project B"
},
:
{
dcount_ID : 10 ,
sum_hours : 38 ,
owner_name : "Michael 2" ,
project_name : null
},
$$ROLLUP :
{
dcount_ID : 12 ,
sum_hours : 40
}
},
Michael 3 :
{
$$ROLLUP :
{
dcount_ID : 8 ,
sum_hours : 48
},
:
{
dcount_ID : 8 ,
sum_hours : 48 ,
owner_name : "Michael 3" ,
project_name : null
}
},
Michael 4 :
{
Project C :
{
dcount_ID : 11 ,
sum_hours : 30 ,
owner_name : "Michael 4" ,
project_name : "Project C"
},
$$ROLLUP :
{
dcount_ID : 13 ,
sum_hours : 40
},
:
{
dcount_ID : 2 ,
sum_hours : 10 ,
owner_name : "Michael 4" ,
project_name : null
}
},
$$ROLLUP :
{
dcount_ID : 40 ,
sum_hours : 172
}
}
} Doug Den Hoed - AtAppStore Got Skills? Lend a hand!
https://community.workfront.com/participate/unanswered-threads -------------
