Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
4 Odpowiedzi
9474 Widoki

Hi Everyone!

I need to sort the data by Next Activity Deadline in CRM which is relational field. By default in Odoo, we don't have right to sort any relational field.

Any idea how to do sorting of this relational field?

Awatar
Odrzuć

specifically which relation field many2one, x2many? field name?

Najlepsza odpowiedź

Hi. Do you tested storing the field? Odoo needs stored field to do a sort.

Awatar
Odrzuć
Najlepsza odpowiedź

I had a similar problem and I solved it by creating a second computed field and use this where required.

Example to get the idea:

@api.multi
def _compute_sorted_related_records(self):
for record in self:
record.sorted_related_records = record.related_records.sorted(
key=lambda r: r.my_sort_field
).ids

sorted_related_records = fields.Many2many(
'related.model',
compute=_compute_sorted_related_records,
)
Awatar
Odrzuć
Autor Najlepsza odpowiedź

Ravi Gadhia

I need to sort activity_date_deadline field in CRM which is datetime type field and that field is not stored in database

Awatar
Odrzuć
Najlepsza odpowiedź

You can add '_order' comment to sort record while listing out in list view. In that you can assign your field name and sorting method.


Awatar
Odrzuć
Autor

Relational field is not working in _order method

Powiązane posty Odpowiedzi Widoki Czynność
0
lut 25
1316
0
sty 25
1138
1
gru 24
1466
1
cze 22
5603
1
lut 19
4982