Passa al contenuto
Menu
È necessario essere registrati per interagire con la community.
La domanda è stata contrassegnata
4 Risposte
9562 Visualizzazioni

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?

Avatar
Abbandona

specifically which relation field many2one, x2many? field name?

Risposta migliore

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

Avatar
Abbandona
Risposta migliore

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,
)
Avatar
Abbandona
Autore Risposta migliore

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

Avatar
Abbandona
Risposta migliore

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.


Avatar
Abbandona
Autore

Relational field is not working in _order method

Post correlati Risposte Visualizzazioni Attività
0
feb 25
1432
0
gen 25
1202
1
dic 24
1572
1
giu 22
5734
1
feb 19
5060