Hi!
Could you help me?
I want to get report on Duration for specific user and I want to get duration amount in an hours (because it's saved in an hours), I use API call /V2.0/services/data/
{
"typeName": "Timesheet",
"aggregations": [
{
"function": "Sum",
"fieldName": "duration",
"alias": "duration"
}
],
"where": {
"and": [
{
"leftExpression": {"fieldName": "reportedDate"},
"operator": "GreaterThanOrEqual",
"rightExpression": {"value": "2018-12-01"}
},
{
"leftExpression": {"fieldName": "reportedDate"},
"operator": "LessThanOrEqual",
"rightExpression": {"value": "2018-12-31"}
},
{
"leftExpression": {"fieldName": "reportedby"},
"operator": "Equal",
"rightExpression": {"value": "/User/
}
]
}
}
but in the response I get the sum in the days. For example, user tracked 40.5 h for month, in the response I get 5.0625. How can I get the sum in an hours using this api call?
Please sign in to leave a comment.
Hello Bvy,
I'm not sure if there's a way to output the sum in hours.
My recommendation is to simply multiply the result by 8. If that is not a satisfactory solution, an alternative way would be to create a custom numeric formula field on the Timesheet entity that expresses Duration as number of hours and then using that in your API call:
Please let me know if this is helpful.
Thank you!
