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

Hello,

How we can make a dynamique _order in py ? for example 

class report_timesheet_task_user(osv.osv):
    _name = "report.timesheet.task.user"
    _auto = False
    _order = "name if a=b, fisrt_name if a>b"

아바타
취소
베스트 답변

Try creating a functional field xxx with store attribute, which loads the function def _get_order(...) like "name if a=b, fisrt_name if a>b" and use this field in (for example) _order ="xxx desc".

UPDATE:

Example:

    @api.one
    @api.depends(
      'sequence',
    )
    def _get_sort(self):
        if self.activity == 'loading':    
          self.sort_dz = self.sequence
        else:         
          self.sort_dz = -self.sequence

    activity = fields.Selection([('loading', 'Loading'),('unloading', 'Unloading')],'Activity Type', required=True, select=True)
    sequence = fields.Integer('Sequence',default=5) 
    sort_dz = fields.Integer('Sort',compute='_get_sort',default=0,store=True)

    _order = "sort_dz desc"

 

아바타
취소
작성자

Hello; i tried it but ot doesn't work

answer updated, show your code, sample code works.

작성자

I have 2 fields: 'date_work':fields.boolean('date'), 'priority_work':fields.boolean('priority') and i have 2 others fields: 'work_priority':fields.integer('priority work'), 'work_date':fields.date('date work') and i want that _order='work_priority desc' when priority_work='t' and date_work='f', and _order='work_date desc' when priority_work='f' and date_work='t', thanks for you

all fields are in the same model?

작성자

Yes sir (y) , this is the diffuculitie

Generally, If yes, it is impossible. How sort all records by parameters from one record??? You may try, like this (where INTEGER you map date to integer), but.... if priority_work='t' and date_work='f' self.sort_dz = self.work_priority else self.sort_dz = INTEGER(work_date) 'sort_dz':fields.integer('sort By') _order='sort_dz desc'

작성자

Thank you zbik, when i'll find a solution i'll tell you

관련 게시물 답글 화면 활동
2
12월 19
4353
3
8월 15
22809
0
2월 16
3029
2
8월 15
6767
1
8월 15
4759