Skip to Content
Menu
This question has been flagged
2 Replies
2118 Views

I need help, I want to color the record in the CRM kanban view in red if my date field date_operation is less than current_date. I write this xml code but nothing happens.

N.B : I have created a date field current_date which gets date.today()

This is my code but the condition unable to executed


<xpath expr="//div[hasclass('oe_kanban_content')]" position="attributes">

      <t t-if="record.date_operation.raw_value < record.current_date.raw_value">

          <attribute name="t-attf-style">color: red;attribute>

      t>

        <t t-else="">

                <attribute name="t-attf-style">color: blue;attribute>

          t>

xpath>

Avatar
Discard
Author Best Answer

Thank you Mr. Jort de Vreeze for your solution, it work perfectly but the problem is in the computed field which calculated only one time, imagine that the date_deadline field is set for a later date, the expired field will not change in the future.

Avatar
Discard

Simply add the depends decorator to the compute method:

@api.depends('date_operation')
def _compute_expired(self):

Best Answer

If I understand you correctly, you could add a Boolean field in your model where you compute if the date is smaller than the current date:

from datetime import datetime, timedelta

expired = fields.Boolean(
    compute='_compute_expired',
    string='Date expired?',
    default=False,
)

def_compute_expired(self):
    date_operation = datetime.now() - timedelta(days=1) # refer to your date_operation field       
    current_date = datetime.now()
    self.expired = True if date_operation < current_date else False

And then apply t-if for this field.


                
                
                
Avatar
Discard
Related Posts Replies Views Activity
1
Mar 24
950
2
Mar 23
2586
0
Jun 21
2088
1
Jul 22
1457
0
Nov 24
68