how to show distict data in many to one filed
8/29/13, 5:20 AM
2,653 views
i want remove repetition from my select box .my code is
def _sel_func(self, cr, uid,context=None):
cr.execute("select distinct on(caller) id,caller FROM calldata1 order by caller")
result = cr.fetchall()
lst = []
for r in result:
dct = {}
dct['id'] = r[o]
dct['name'] = r[1]
lst.append(dct)
res_ids = [(r['id'], r['name']) for r in lst]
return res_ids
_columns = {
'date_start': fields.date('Date Start', required=True),
'date_end': fields.date('Date End', required=True),
'caller_id':fields.many2one(
'calldata1',
'Caller',
selection=_sel_func,
)
}
but it shows all the data in select box and shows error " ValidateError
The value "7172" for the field "calldata_print_report_wiz.caller_id" is not in the selection "
when selecting this and clicking print. How to show only the data from query in select box .Any one please help?
