Eclipse Community Forums: EclipseLink » Calculations of field values using other tables

Help

Home

Home » Eclipse Projects » EclipseLink » Calculations of field values using other tables

Show: Today's Messages :: Show Polls :: Message Navigator

Calculations of field values using other tables [message #390286]

Tue, 14 July 2009 04:51

Philipp Kursawe
Messages: 135
Registered: July 2009

Senior Member

Hello,

is it possible to calculate a fields value using a SQL statement?
I have a progress and a status field that would have to be calculated by
values from another table.

OrderEntity {
float progress;
int shortageLines;
}

The shortageLines field would be calculated by the number of line items
from the line_items table that have been picked with a shortage. The
progress field is the overal % of already picked line items versus the
total number of line items to pick.

Any idea if something like that is possible to "inject" into the object
using JPA?

Thanks,
Phil

Report message to a moderator

[Message index]

		Calculations of field values using other tables By: Philipp Kursawe on Tue, 14 July 2009 04:51
		Re: Calculations of field values using other tables By: James Sutherland on Thu, 16 July 2009 10:04
		Re: Calculations of field values using other tables By: Philipp Kursawe on Thu, 16 July 2009 10:30

Previous Topic:	Unstable database connection causes EL to deadlock
Next Topic:	Create additional views on session start

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 24 10:03:34 EDT 2013