Skip to Content
Menu
This question has been flagged
1 Odpoveď
1317 Zobrazenia

Hi,


I have a custom computed field that I use in v17. This is calculating the latest date among a list of dates


When I upgraded to v18 on a test database, I get the following error

ValueError: Cannot convert mycustommodel.mycustomfield to SQL because it is not stored

If I change the parameter of my field  to "stored", then I no longer have the error but the field isn't computed anymore. Empty.


Here is the Python code for the computation :

for record in self:

    dates = []

    for line in record.custommodelwheremydatesare:

        if line.fieldwithdate:

            dates.append(line.fieldwithdate)

    if dates:

        record['mycustomcomputedfield'] = max(dates)

    else:

        record['mycustomcomputedfield'] = False


Any idea ?

Avatar
Zrušiť
Autor Best Answer

OK I understood. The problem was because my list view was sorted according this computed field.

It didn't work but I left it that way.

When you migrate to v18, what was a mere useless option ended up crashing the interface.

Takeaway : do not sort your list using a computed field

Avatar
Zrušiť
Related Posts Replies Zobrazenia Aktivita
1
apr 24
2558
4
jan 24
1876
1
máj 21
4486
1
júl 25
659
1
dec 24
2020