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!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign upRelated Posts | Replies | Views | Activity | |
---|---|---|---|---|
|
0
Oct 24
|
118 | ||
|
1
Apr 24
|
972 | ||
|
7
Sep 24
|
22461 | ||
|
1
Mar 24
|
278 | ||
|
0
Feb 24
|
422 |