Skip to Content
Menu
This question has been flagged
1 Reply
3154 Views

i am not able to get image column using database query 

mthod:

@ api.model 
def _get_report_values ( self , docids , data = None ):
model = self .env.context.get ( 'active_model' )
self ._cr.execute ( "" "select DISTINCT first_name, image_1920,     x_id_number_student, blood_group, birth_date, name from op_student
inner join op_student_course
on op_student.id = op_student_course.student_id
inner join op_course
    on op_course.id = op_student_course.course_id "" " )
docs = self ._cr.fetchall ()
logging.info ("************************************************** 8 " )
logging.info (docs)
 
return { 'doc_ids' : self .ids ,
'doc_model' : model ,
'docs' : docs ,
'data' : data } 
Avatar
Discard
Best Answer

Dear Paidy,

Try to get value from object. 

<span t-field="doc.image" t-options="{'widget': 'image'}"/>

Regards,

Silvestar


Avatar
Discard
Author

Dear silverstar

I am not returning anything into doc here...

but you will get values in'docs' : docs .

Author

in docs i assigned query data.in docs there is only query fetched data only.can you please tell me how to get image through query.

Related Posts Replies Views Activity
0
Sep 23
5179
1
Jul 23
1323
0
May 23
1488
3
Apr 23
18766
1
Nov 22
860