Skip to Content
Menu
This question has been flagged
4 Replies
7720 Views

Hi,

how can i order by key 'date' an array like this in qweb report? Odoo v11

[{'id':'1', 'date':'2019-05-01'},{'id':'2', 'date':'2018-01-01'},{'id':'3', 'date':'2019-01-01'}]

Avatar
Discard

Odoo Tips, Hope this will helps: https://old.reddit.com/r/learnopenerp/

Best Answer

Hello

please try with below code:

from operator import itemgetter
list_to_be_sorted = [{'id':'1', 'date':'2019-05-01'},{'id':'2', 'date':'2018-01-01'},{'id':'3', 'date':'2019-01-01'}]
newlist = sorted(list_to_be_sorted, key=itemgetter('date'))
print newlist
Avatar
Discard

for qweb, <t t-foreach="sorted(list_to_be_sorted, key=itemgetter('date'))" t-as="record">

...

</t>

Best Answer

In QWeb Report you can order them like in Python code:

 <tr t-foreach="docs.sorted(key=lambda x: x.date)" t-as="item">

    ...

</tr>

Avatar
Discard
Author Best Answer

With expression:
OrderedDict(sorted(Lines[o.id][currency].items(), key=lambda t: t[0]))

The error is:
AttributeError: 'list' object has no attribute 'items'


With expression:
Lines[o.id][currency].sorted(key=lambda b: b[0])

The error is:
AttributeError: 'list' object has no attribute 'sorted'

Avatar
Discard
Best Answer

Try this:


ordered = OrderedDict(sorted(mydict.items(), key=lambda t: t[0]))

Avatar
Discard