跳至內容
選單
此問題已被標幟
2842 瀏覽次數

Example is here

please correct this code....


from odoo import api, fields, models, tools

class PosOrderReport(models.Model):
 _name = "report.pos.order"   

_description = "Point of Sale Orders Statistics"

_auto = False

_order = 'date desc'
date = fields.Datetime(string='Date Order', readonly=True)   

order_id = fields.Many2one('pos.order', string='Order', readonly=True)



@api.model_cr

def init(self):
 tools.drop_view_if_exists(self._cr, 'report_pos_order') 

self._cr.execute("""           

CREATE OR REPLACE VIEW report_pos_order AS (               

SELECT  

                

s.date_order AS date,

s.id as order_id,

s.date_order || s.id as order with date    # this is not working please any solution

FROM table s


頭像
捨棄
相關帖文 回覆 瀏覽次數 活動
1
12月 17
3949
0
11月 17
3059
1
7月 17
5420
0
3月 17
2936
0
1月 17
3140