Skip to Content
Menu
This question has been flagged

I want to updated time value in float field from datetime field by psql query odoo 14. So, i can i get this.

My code is below:

start_datetime = fields.Datetime("Start DateTime", required=True)
duration = fields.Float('Duration', readonly=True)

def init(self):
    '''Create the view'''
    tools.drop_view_if_exists(self._cr, self._table)
    self._cr.execute("""
    CREATE OR REPLACE VIEW %s AS (
    SELECT
     ROW_NUMBER() OVER() as id,

     aal.start_datetime as start_datetime,
     (start_datetime at time zone 'utc') ::timestamp as duration
     --Try to update above duration field with time only
     from account_analytic_line aal
     left join project_project pro on pro.id = aal.project_id
    )""" % (self._table,))

Thanks in advance.


Avatar
Discard
Related Posts Replies Views Activity
1
May 24
1433
1
Apr 24
23238
1
Nov 22
1400
2
Jul 22
1798
2
Jul 22
1820