summing a column and other math...
summing a column and other math...
- Subject: summing a column and other math...
- From: Theodore Petrosky <email@hidden>
- Date: Thu, 10 Jun 2010 08:16:10 -0700 (PDT)
I need some help doing 'simple' math with my objects...
relationships:
client =>> contract and =>> project
project <=>> contract
project <=>> job
job <=>> etime
a contract has assignedHours
eTime has usedHours
I am using a displayGroup to show my eTime entries...
<webobject name = "TimeListRep">
<webobject name = "RowColorGenericContainer">
<td><wo:WOString value = "$theTimeListItem.user.fullNameString" /></td>
<td><wo:WOString value = "$theTimeListItem.amountOfTime" numberformat = "##.##" /></td>
<td><wo:WOString value = "$theTimeListItem.workTask.workTaskTitle" /></td>
<td><wo:WOString value = "$theTimeListItem.timeDate" dateformat = "%m.%d.%Y" /></td>
</webobject>
</webobject>
TimeListRep : WORepetition {
list = timeListDG.displayedObjects;
item = theTimeListItem;
index = session.index;
}
I need to sum the second column value = "$theTimeListItem.amountOfTime"
and subtract it from the assignedHours in the contract....
I can pull the contract from: theContract = timeList.objectAtIndex(0).job().project().contract();
and then get theContract.assignedHours
(timeList is the array that feeds the displayGroup)
In SQL I would:
select 1500 - sum(c_amount_of_time) from t_e_time where c_job_id IN (SELECT id FROM t_job WHERE c_project_id = 16);
where 1500 represents the assignedHours from the contract entity..
I know there is a webobjects way... I just can't find it without help.
I could:
int theAssignedHours = timeList.objectAtIndex(0).job().project().contract().assignedHours();
then the raw SQL to get the sum of eTime used for this contract and subtract....
I hope I am clear.......
Ted
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden