تخطي للذهاب إلى المحتوى
القائمة
لقد تم الإبلاغ عن هذا السؤال
1 الرد
6159 أدوات العرض

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?

الصورة الرمزية
إهمال
أفضل إجابة

Try to add a field 'name' to the object you display through many2one

الصورة الرمزية
إهمال
الكاتب

adding name field corrected the issue

الكاتب

How can io get distict value for this name filed?

الكاتب

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.

المنشورات ذات الصلة الردود أدوات العرض النشاط
0
أكتوبر 20
3178
1
أغسطس 17
3653
0
مارس 15
3028
1
سبتمبر 23
1662
1
يوليو 19
6727