コンテンツへスキップ
この質問にフラグが付けられました
computestudiocomputed-fieldsStudio
2 返信
6176 ビュー
アバター
Emilia Taylor

Hello,

With studio, I have added a float field. I would like in Advanced Properties ‘compute’ a calculation. The calculation is working fine. But now, I want to add a condition ‘if contains’. I have tried with

  • if (record.taxes_id.__contains__(‘test')):
  • if record.taxes_id == “test":

The first one is not working and the second one is working if the field is for instance a char. However taxes_id is a M2M, which is the issue. 

- I have tried to add a [0] after taxes_id but the result is always false
- I have tried to add in a char field :  for record in self: record['x_studio_test2'] = record.taxes_id, in order to see the value. It’s for instance (account.tax(1,).
       - If I do the same with [0], I have still the same result.
       - If I do the same with if record.taxes_id == "account.tax(1,)": I have always false.

How could I do to have my condition that research inside the table ? The goal is to say if 1 (or something else like to a value in a table of a M2M(taxes_id)) that works. Means that is not always false...


アバター
破棄
アバター
Vincent GUILLAUME
最善の回答

Hi, i have the same problem with a condition based on single bolean field :

ASS EXT : True

This is the calculated field :

for record in self:
if x_studio_assist_ext == TRUE:
record['x_studio_primes_ttc_12'] = record.x_studio_rc_cost + record.x_studio_mr_costs + record.x_studio_dm_cost + record.x_studio_cots_assist + record.x_studio_cond_cost + record.x_studio_pj_cost
else :
record['x_studio_primes_ttc_12'] = 0

and it do not work ...

Could you help me ?

アバター
破棄
アバター
Eman Abdulmalik
最善の回答

Hello

First set a boolean value, then loop through the many2many fields and do an OR operator like below:


Many2many field is - tax_ids
Boolean variable is - control_var


control_var = False

for i in record.tax_ids:
    control_var = control_var or i.name == 'test'

if control_var == True:
    //this will be your condition



アバター
破棄
関連投稿 返信 ビュー 活動
Error message when clicking any item on any page in the studio editor
studio Studio
アバター
アバター
1
4月 25
2267
odoo studio how to create parent and subcategory in new custom module
studio Studio
アバター
アバター
1
2月 24
3680
Computed Field Using Two Different Models
computed-fields Studio
アバター
アバター
1
4月 24
3702
computed field made in Odoo Studio that can be calculated on base of two other field or set by the user based on if the depending fields have a value.
studio computed-fields
アバター
0
2月 24
3135
New group label like Sales in Contacts (v14)
studio Studio
アバター
0
9月 21
2606