Hi Friends,
I have wrote onchange function for the journals to viewed for different type of name fields.But the query retruns the values only after executing query in pgadmin
def onchange_sequence(self, cr, uid, id, sequence_type, context=None):
res = []
if sequence_type:
# value = super(invoice_changes, self).onchange_sequence(cr, uid, id, sequence_type, context)
cr.execute('select jl.journal_id\
from journal_type as jt\
left join journal_lines as jl on(jl.journ_id = jt.id)\
left join account_invoice as ai on (ai.sequence_type = jt.id)\
left join res_company as rc on (rc.id = jt.company_id)\
where ai.sequence_type = %s', (sequence_type,))
for result in cr.fetchall():
print "\n\n resultssssssssssssssssssssssssssssssssssssssssssssssss",result
res.append(result[0])
return {
'domain': {
'journal_id': [('id', 'in', res)]
} }
return {}
please help me to resolve this problem