Aggregations - How to get the row name which is aggregated?
Hi,
I am trying to get summation of Timespent from Child Actions on the parent Objects (Custom Work Item). For each of the object, I fetch all the children.
For the Parent table and the child table I have grouped by WorkItem Id and did some aggregation. At the child aggregated values are timespent, planned start date(custom field), due date, actual start date(custom field) and actual end date (custom field).
If I want to take summation of this aggregated timespent of each child how should I refer the aggreagated value. I tried row when doing the summation script on 'onFetch' method for the child. But it failed.
On the same line I want to do a comparison on the aggregated dates. How should I refer the aggregated dates?
I am trying to get summation of Timespent from Child Actions on the parent Objects (Custom Work Item). For each of the object, I fetch all the children.
For the Parent table and the child table I have grouped by WorkItem Id and did some aggregation. At the child aggregated values are timespent, planned start date(custom field), due date, actual start date(custom field) and actual end date (custom field).
If I want to take summation of this aggregated timespent of each child how should I refer the aggreagated value. I tried row when doing the summation script on 'onFetch' method for the child. But it failed.
On the same line I want to do a comparison on the aggregated dates. How should I refer the aggregated dates?
One answer
Hi,
I am trying to get summation of Timespent from Child Actions on the parent Objects (Custom Work Item). For each of the object, I fetch all the children.
For the Parent table and the child table I have grouped by WorkItem Id and did some aggregation. At the child aggregated values are timespent, planned start date(custom field), due date, actual start date(custom field) and actual end date (custom field).
If I want to take summation of this aggregated timespent of each child how should I refer the aggreagated value. I tried row when doing the summation script on 'onFetch' method for the child. But it failed.
On the same line I want to do a comparison on the aggregated dates. How should I refer the aggregated dates?
Hi All,
I got this resolved with the use of some scripting. I removed aggregations from the child actions.
Thank you
Dhanya