I didn't know that the Entity Engine can create temporary tables. Can it?
Jonathon
Jacques Le Roux wrote:
Also have a look at Factory Methods in
http://ofbiz.apache.org/docs/entity.html#The_Entity_Engine_API
Jacques
Did you have a look at the entity engine API ? You might have to use "ant docs"
to build javadoc locally because at this point I'm
not sure there is an API access online. Then look at
framework/entity/build/javadocs/index.html
BTW we should do something for that, is there an issue which explains why we
don't do it on
site ?
Jacques
De : "Jose Diaz" <[EMAIL PROTECTED]>
Please, let me know some advice about this:
I need work with temporal tables, it because I don't want to create a table for
save data and next delete it. Create your
entity,
update the entitygroup, etc.
I am updating the aging report , because the data in the future will be bigger.
Then I am doing a service that load the data all the days (midnight) in a table
and i only read of it for show the aging report.
For it, I need a temporal table that save the data of the service:
Map invoicesByDSO =
AccountsHelper.getUnpaidInvoicesForCustomers(organizationPartyId,
daysOutstandingPoints, asOfDateTime,
delegator);
Next, group the data in it format more simple :
LocationAccountCurrent< 3031 - 6061 - 90> 90Total
3 Oaks Car Wash - MasterN746109010 327.74 - -
- - 327.74
7035 PROPERTIES 1 - MasterK300750001 - 1,321.06 -
- - 1,321.06
7035 PROPERTIES 2 - MasterT931471026 - 219.98 -
- - 219.98
A B S Graphics - MasterQ268095009 4,162.01 - -
- - 4,162.01
In conclusion, is possible create temporal tables in a java service??
Jose Diaz
