Is it posible to sort on a date field in QWEB report?
<tr t-foreach="getLines(o)" t-as="line">
<td>
<span t-field="line.date"/> <===
</td>
<td>
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Is it posible to sort on a date field in QWEB report?
<tr t-foreach="getLines(o)" t-as="line">
<td>
<span t-field="line.date"/> <===
</td>
<td>
Hi,
One option is to inherit the model in your python file and add _order to sort the date in desc or asc. Then the report will be with sorted dates.
For eg:
class model_name(models.Model):
_inherit = 'model.name'
_order = 'date desc'
Another option is to modify the getLines() to return the records sorted by date field. For example, if you are having a recordset at the end of the function, sort it by date and then return.
For eg: (if you are working with new api)
def getLines(self,object):
moveline_obj = self.env['account.move.line']
movelines = moveline_obj.browse([self.id])
recordset = movelines.sorted(key=lambda r: r.date)
return recordset
Is it also possible to use python code in qweb? https://www.odoo.com/fr_FR/forum/help-1/question/qweb-report-sort-by-and-multi-lines-if-number-of-code-in-a-field-exceed-x-number-49722
Hi Mario, I modified the answer. please check
Hi Akhil, your solution with getlines () works, Many thanks!
Cree una cuenta para poder utilizar funciones exclusivas e interactuar con la comunidad.
InscribirsePublicaciones relacionadas | Respuestas | Vistas | Actividad | |
---|---|---|---|---|
|
1
may 25
|
588 | ||
|
1
abr 25
|
1700 | ||
|
1
feb 25
|
839 | ||
|
0
abr 25
|
887 | ||
|
0
oct 24
|
690 |