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 Software Solutions) · 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!

相關帖文	回覆	瀏覽次數
Create schedule action For sending emails odoo10	2 7月 25	4259
How to send messages that are not shown in chatter? odoo10	2 12月 24	7491
Dynamic domain functionality - possible to change domain of a field in another model with onchange? (Odoo 10) 已解決 odoo10	2 5月 24	7244
Change state of other module odoo10	3 3月 24	6679
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	1475

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！