c2c-oerpscenario team mailing list archive
-
c2c-oerpscenario team
-
Mailing list archive
-
Message #29338
[Bug 816561] Re: Pb with complex domain expressions
xrg : thanks for investigating this issue with me !
I am currently reproducing the issue with OpenERP server 6.0 (up-to-date
bzr branch) and OpenERP client 6.0 (up-to-date bzr branch).
The module in which my code is : coface_credit_insurance
lp:~akretion-team/+junk/coface_credit_insurance last revision (rev 27)
Once the module is installed, I create 4 invoices :
- 1 customer invoice for Asustek in state open
- 1 customer invoice for Distrib PC in state open
- 1 customer refund for Asustek in state open
- 1 customer invoice for Distrib PC in state draft
Then, go to Financial management > Coface > "DMS to do", and you have a
tree view with 4 invoices, where as you should only get 2 invoices if
you refer to invoice_view.xml line 73.
This time, I started my OpenERP client 6.0 through command line, and I
saw this message when opening the "DMS to do" menu entry :
ERROR:tools.expr_eval:['&', '&', '|', '&', ('address_invoice_id.country_id.name', '=', 'Taiwan'), ('partner_id.name', '=', 'ASUStek'), '&', ('address_invoice_id.country_id.name', '=', 'Belgium'), ('partner_id.name', '=', 'Distrib PC'), ('state', '=', 'open'), ('type','=',
Traceback (most recent call last):
File "/home/alexis/new_boite/dev/openobject-client-6.0/bin/tools/__init__.py", line 52, in expr_eval
temp = eval(string, context)
File "<string>", line 1
['&', '&', '|', '&', ('address_invoice_id.country_id.name', '=', 'Taiwan'), ('partner_id.name', '=', 'ASUStek'), '&', ('address_invoice_id.country_id.name', '=', 'Belgium'), ('partner_id.name', '=', 'Distrib PC'), ('state', '=', 'open'), ('type','=',
^
SyntaxError: unexpected EOF while parsing
So it's clearly linked to my problem ! I guess we are getting closer to
finding the issue !
--
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/816561
Title:
Pb with complex domain expressions
Status in OpenERP Server:
New
Bug description:
I have a problem with complex domain expressions ; it may be a bug of
the OpenERP server, but it may also be a bad domain expression due to
a bad comprehension of the way it is supposed to work.
In an ir.actions.act_window on the object account.invoice :
1) I want to filter on open invoice/refunds that are either from
Asustek with country = Taiwan or from Direct PC with country =
Belgium, so I write the following expression :
<field name="domain">['&', '|', '&',
('address_invoice_id.country_id.name', '=', 'Taiwan'),
('partner_id.name', '=', 'ASUStek'), '&',
('address_invoice_id.country_id.name', '=', 'Belgium'),
('partner_id.name', '=', 'Distrib PC'), ('state', '=',
'open')]</field>
Result : it works OK.
2) I want to filter on open customer invoices that are either from
Asustek with country = Taiwan or from Direct PC with country =
Belgium, so I write the following expression :
<field name="domain">['&', '&', '|', '&',
('address_invoice_id.country_id.name', '=', 'Taiwan'),
('partner_id.name', '=', 'ASUStek'), '&',
('address_invoice_id.country_id.name', '=', 'Belgium'),
('partner_id.name', '=', 'Distrib PC'), ('state', '=', 'open'),
('type', '=', 'out_invoice')]</field>
Result : NOT OK, I get ALL the invoices !
I have this problem with OpenERP server branch 5.0 and branch 6.0 ; I
wanted to test on trunk, but I can't find the "Modules" menu entry to
install my module !
By the way, my source of information about complex domain expressions is this one :
http://christophe-simonis-at-tiny.blogspot.com/2008/08/new-new-domain-notation.html
plus wikipedia to understand "polish expressions" and "arity".
To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-server/+bug/816561/+subscriptions
Follow ups
References