Ir al contenido
Menú
Se marcó esta pregunta
2 Respuestas
7644 Vistas

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
Descartar
Autor

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

Mejor respuesta

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
Descartar
Mejor respuesta

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
Descartar
Publicaciones relacionadas Respuestas Vistas Actividad
1
jul 25
2691
1
may 25
3302
1
abr 25
3041
1
feb 25
2410
0
oct 24
1968