openerp-expert-accounting team mailing list archive

Thread
Date

use of sequences for generation of unique id of complex views

To: openerp-expert-accounting@xxxxxxxxxxxxxxxxxxx
From: Ferdinand Gassauer <office@xxxxxxxxxx>
Date: Fri, 15 Oct 2010 00:06:14 +0200
Cc: Panos Christeas <xrg@xxxxxxxxx>
Organization: ChriCar Beteiligungss- und Beratungs- GmbH
User-agent: KMail/1.13.5 (Linux/2.6.34.7-0.3-desktop; KDE/4.5.2; x86_64; ; )

Hello 
We have tried to create a view using nextval(seq) as id
see attached module (which will not install without modification due to 
missing menu entry)

after creating the sequence and rule manually the module loads
GTK and Web immediately display nothing
Koo takes a long time to fetch all records (given the id numbers it must have 
read the table multiple times)
querying a category for example returns 4 "empty" rows 

I suspect that the server tryes to lock the rows (which IMHO does not make 
much sense for immutable views)

Questions
* is it possible to use sequences  and if yes how to do this
* IMHO OpenERP should provide a method to generate "usable" ids for complex 
views where the id can not simply be generated using id's form the underlying 
tables.

thank you for looking into this issue.
  
-- 
regards
Ferdinand Gassauer
ChriCar Beteiligungs- und Beratungs- GmbH
Official OpenERP Partner

Attachment: dimu_partner_category_country.zip
Description: Zip archive