Skip to Content
Menu
This question has been flagged
2 Replies
6135 Views

How change format display a field in qweb report?


function in python file:

def _get_name(self,partner_id):

    sql = """ select name as name1 from res_partner
                    where id=%s """ %(partner_id)
    self.env.cr.execute(sql)
    return self.env.cr.dictfetchone()


template xml:

            <span t-esc="get_name(partner_id)"/>

output pdf report:


    {'name1': mosao}


I want just display: mosao

please help me.

Avatar
Discard
Author

Hi Anu and Sudhir Arya, Thanks for your answer correct.

Best Answer

dictfetchone will give you the dictionary for the single record. So you have to fetch the value from the dict.

Try following code:

return self.env.cr.dictfetchone().get('name1', '')

See different python fetch types for fetching data from query.

Avatar
Discard
Best Answer

Hi,

  just try any of the following

     <span t-esc="get_name(partner_id)['name1']"/>

or 
      record =  self.env.cr.dictfetchone() 

 retrun record['name1']                                                                                                          

Avatar
Discard
Related Posts Replies Views Activity
0
Oct 24
117
1
Apr 24
965
7
Sep 24
22445
1
Mar 24
275
0
Feb 24
410