singleton

Question

Hi
How are you everybody?
I have this problem  thank you
ValueErrorExpected singleton: financial.grant(1, 3, 4)

Yenthe Van Ginneken (Mainframe Monkey) · Accepted Answer

Hi Salama,

A singleton error means that the result that you get contains multiple values while your code expects one record to be returned.
You can solve this by looping over the records and doing your logic there. For example:

for grant in financial_grant:
print('grant record: ' + str(grant.name))

Odoo is telling you that the result contains a recordset, so multiple records, while it expected one.
There can be a lot of reasons for this but usually it means that you're not looping over record

Salama Sidna · Answer

@api.one
@api.depends('required_hours','completed_hours')#,'seniority_classamount_amount','seniority_pay','category_class_basic_grant','diplom_premium','performance_bonus','grade_premium','sem_owe_him')
def presence_avarage_count(self):
for r in self:
if r.required_hours > r.completed_hours :
r.presence_avarage = (float)(r.completed_hours / r.required_hours)
r.percentage_presence_avarage = r.presence_avarage * 100
else:
r.presence_avarage = -2

@api.one
@api.depends('presence_avarage','g_spy',

This question has been flagged

Enjoying the discussion? Don't just read, join in!