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"
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Księgowość
- Zapasy
- PoS
- Project
- MRP
To pytanie dostało ostrzeżenie
1
Odpowiedz
6087
Widoki
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
Podoba Ci się ta dyskusja? Dołącz do niej!
Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!
Zarejestruj się| Powiązane posty | Odpowiedzi | Widoki | Czynność | |
|---|---|---|---|---|
|
2
gru 19
|
4099 | ||
|
3
sie 15
|
22408 | ||
|
0
lut 16
|
2763 | ||
|
2
sie 15
|
6530 | ||
|
1
sie 15
|
4424 |
