Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
2 Odpovědi
7187 Zobrazení

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
Zrušit
Autor

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

Nejlepší odpověď

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
Zrušit
Nejlepší odpověď

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
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
1
čvc 25
1962
1
kvě 25
2050
1
dub 25
2483
1
úno 25
1754
0
říj 24
1495