How to ORDER BY? [Odoo 10]

Question

@http.route(['/signage','/signage/list'],type='http', auth='user', website=True)
def signage_list(self, **post):
return request.render('signage.signage_list', {'signages': request.env['signage.signage'].search([('state','=','open')])})
ORDER BY! How do I write it Odoo style!?

Niyas Raphy (Walnut IT) · Accepted Answer

Hi,
See a sample code of order done in the search method,
partner_sales = self.env['sale.order'].search([('partner_id','=', partner)], *order="id desc")*

In the above example the search method will return the result in the descending order of the id.

Thanks

Jakob Krabbe · Answer

Thank you! It's the same answer as I found myself, but I got the details mixed up... :-)
Another answer would be: <ul t-foreach="signages.sorted(lambda s: s.template_id)" t-as="signage">
but I like "order", the way you write!

相关帖文	回复	查看
How to send messages that are not shown in chatter? odoo10	2 12月 24	6688
Dynamic domain functionality - possible to change domain of a field in another model with onchange? (Odoo 10) 已解决 odoo10	2 5月 24	6466
Change state of other module odoo10	3 3月 24	5837
The save button function from the application menu in recruitment is not the same with the save button function on the button from a form link to the applications menu. odoo10	0 3月 24	931
Is it possible to hide the cost price of the product in the Product view? 已解决 odoo10	3 2月 24	12163

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！