I have create a the view via sql, but data is not showing and no error are coming?
Please help me on it.
what is wrong on this code?
==================Model===========odoo 12========
from odoo import api, fields, models
from odoo import tools
class adminssionverify(models.Model):
_name = 'adminssionverify.adminssionverify'
_description = "Admission"
_auto = False
getStuname = fields.Char(string='Name')
@api.model_cr
def int(self):
tools.drop_view_if_exists(self._cr, 'adminssionverify_adminssionverify')
self._cr.execute("""
CREATE OR REPLACE VIEW adminssionverify_adminssionverify AS (
SELECT row_number() OVER() AS id, line.getStuname FROM (
SELECT st.name as getStuname
FROM student_student st
) line
)""")
=================View==================
teacher list
adminssionverify.adminssionverify
Student teacher window
ir.actions.act_window
adminssionverify.adminssionverify
tree,form