Hello everyone,
I am trying to create a group for my search view which includes a many2many field.
When I try to load the "group by" option I have created for this many2many field, I get the error:
assert gb_field.store and gb_field.column_type, "Fields in 'groupby' must be regular database-persisted fields (no function or related fields), or function fields with store=True"
AssertionError: Fields in 'groupby' must be regular database-persisted fields (no function or related fields), or function fields with store=True
My many2many field is declared as:
mechanic_ids = fields.Many2many('res.users', relation='timesheet_rel_users', column1='id',column2='name')
On XML for the search view I have:
The above error is raised when I try to load this specific "group by" option.
Is there any way I can create a "group by" option which includes a many2many field?
Thank you in advance
Best regards
Paulo
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Comptabilitat
- Inventari
- PoS
- Projectes
- MRP
This question has been flagged
It is not possible to group by many2many field.
In that case the line might be shown on the Odoo interface more than one time, what is not acceptable.
As alternative you can create a many2one field which would compute the 'main' record from many2many. For example, you can group partner by tags, but you can group by some computed 'main tag'.
Besides, search by many2many field would work. An example from res.partner:
<field name="category_id" string="Tag" filter_domain="[('category_id','ilike', self)]"/>Also you may generate some custom report for your model, which would join tables in the way you like (SQL statement).
UPDATE
@api.multi
@api.depends('mechanic_ids')
def _compute_mynewfield_id(self):
for record in self:
record.mynewfield_id = record.mechanic_ids and record.mechanic_ids[0] or False
mynewfield_id = fields.Many2one('mechanic_ids', compute=_compute_mynewfield_id, store=True) # it is possible to search only among stored fields
Hi @Odoo Tools,
Thank you very much once again for your help on my path on learning Odoo development.
I have tried to create a "computed" field for this purpose I was unable to do it.
Can you please help me with a sample code?
My many2many field is declared as:
myfield_ids = fields.Many2many('res.users', relation='timesheet_rel_users', column1='id',column2='name')
I have tried to create a many2one computed field declared as:
mynewfield_id = fields.Many2one('mechanic_ids', compute='_get_values, store=False)
My incomplete function:
@api.one
@api.depends('mechanic_ids')
def _get_values(self):
value = self.mechanic_ids
for record in value:
I am stuck from this point forward.
From here, If I print the "value", I can get the desired value for every and each record, but do not know how to complete the function and pass it to XML view filter.
Thank you once again
Best regards
Paulo
see the update
Dear @Odoo Tools,
Thank you very very much once again.
+1000 for you
Best regards
Paulo
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Registrar-se| Related Posts | Respostes | Vistes | Activitat | |
|---|---|---|---|---|
|
2
de jul. 19
|
12021 | ||
|
|
1
de juny 19
|
7699 | ||
|
0
de febr. 23
|
3353 | ||
|
1
d’ag. 21
|
12297 | ||
|
1
d’ag. 24
|
8617 |
