콘텐츠로 건너뛰기
메뉴
커뮤니티에 참여하려면 회원 가입을 하시기 바랍니다.
신고된 질문입니다

Hi Friends,

I am working odoo v 7.0.I have search by some condition from account_invoice table and filtered some records.I have got some ids of records.Now i have to order those ids by date_invoice field.How it will be resolved? . Please help me in this situation.Thanks in advance.

아바타
취소
베스트 답변

Hi @vadivel

If you are calling search by yourself you could pass the order that you need like:

posted_depreciation_line_ids = depreciation_lin_obj.search(cr, uid, [('asset_id', '=', asset.id), ('move_check', '=', True)],order='depreciation_date desc')

I include the method doctring that parse and generate the order by based on the order argument of the search method:

    def _generate_order_by(self, order_spec, query):
"""
Attempt to consruct an appropriate ORDER BY clause based on order_spec, which must be
a comma-separated list of valid field names, optionally followed by an ASC or DESC direction.

:raise" except_orm in case order_spec is malformed
"""
아바타
취소
작성자

Thank you so much @Axel Mendoza..This query saves lots of time..

Happy to help you, could you accept the answer too?

작성자

Yes Axel..I did.Also one more help.Can we define sorting by more than one fields.Need to add one more field in order.Is it possible.?

Yes, see the answer update for more. The accept on the question is the check mark bellow the upvote

Did you see it?

관련 게시물 답글 화면 활동
2
3월 15
8303
4
7월 17
21120
3
3월 15
3969
0
3월 15
4547
0
3월 15
2992