Skip to Content
This question has been flagged
xmlrpc
2 Replies
4073 Views
Avatar
Jesse Rye

I am trying to search for records in account.move.line by partner_ids. I'm first searching the res.partner table and then  passing the ids from that search into the account_move_line_ids search but I get an error "INVALID LEAF". Can someone help me understand whats going wrong?


supplier_ids = sock.execute( dbname, uid, pwd, 'res.partner', 'search', [( 'supplier', '=', True ), '|', ( 'active', '=', True ), ( 'active', '=', False )] )
account_move_line_ids = sock.execute( dbname, uid, pwd, 'account.move.line', 'search', [( 'partner_id', 'IN', supplier_ids )] )
Avatar
Discard
Avatar
nikesh
Best Answer

Hi Jesse,

You must use 'in' instead of 'IN' as,

account_move_line_ids = sock.execute(dbname,uid,pwd,'account.move.line','search',[('partner_id','in',supplier_ids)])
Avatar
Discard
Jesse Rye
Author

Thanks. I knew I was missing something simple never thought to change the case of IN. :(

Avatar
sarkarsolution.surat
Best Answer

Hello jesse Rye

can you try like

supplier_ids = sock.execute( dbname, uid, pwd, 'res.partner', 'search', [( 'supplier', '=', True ), '|', ( 'active', '=', True ), ( 'active', '=', False )] )

 move_id = []

for move in supplier_ids:
           id = sock.execute( dbname, uid, pwd, 'account.move.line', 'search', [( 'partner_id', 'IN', move )] ).id
          move_id.append(id)

print "===========", move_id

Avatar
Discard
Related Posts Replies Views Activity
Cannot marshal None unless allow_none is enabled
xmlrpc
Avatar
1
Oct 24
266
How to run a method from external api as the superuser
xmlrpc
Avatar
Avatar
1
Apr 24
508
xmlrpc Error when attempting to connect to my local instance Solved
xmlrpc
Avatar
Avatar
2
Mar 24
734
<methodName>execute</methodName>
xmlrpc
Avatar
0
Sep 23
575
XmlRpc read failed
xmlrpc
Avatar
Avatar
1
Jun 23
817