Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
2 Replies
7055 Tampilan

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
Buang
Penulis

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

Jawaban Terbai

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
Buang
Jawaban Terbai

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
Buang
Post Terkait Replies Tampilan Aktivitas
1
Jul 25
1581
1
Mei 25
1555
1
Apr 25
2183
1
Feb 25
1473
0
Okt 24
1249