function expression in FROM cannot refer to other relations of same query level

Odoo Server Error

Traceback (most recent call last): File "/opt/odoo/odoo11/odoo/http.py", line 650, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/opt/odoo/odoo11/odoo/http.py", line 310, in _handle_exception raise pycompat.reraise(type(exception), exception, sys.exc_info()[2]) File "/opt/odoo/odoo11/odoo/tools/pycompat.py", line 87, in reraise raise value File "/opt/odoo/odoo11/odoo/http.py", line 692, in dispatch result = self._call_function(self.params) File "/opt/odoo/odoo11/odoo/http.py", line 342, in _call_function return checked_call(self.db, *args, *kwargs) File "/opt/odoo/odoo11/odoo/service/model.py", line 97, in wrapper return f(dbname, args, kwargs) File "/opt/odoo/odoo11/odoo/http.py", line 335, in checked_call result = self.endpoint(*a, kw) File "/opt/odoo/odoo11/odoo/http.py", line 936, in call return self.method(*args, *kw) File "/opt/odoo/odoo11/odoo/http.py", line 515, in response_wrap response = f(args, kw) File "/opt/odoo/odoo11/addons/web/controllers/main.py", line 934, in call_kw return self._call_kw(model, method, args, kwargs) File "/opt/odoo/odoo11/addons/web/controllers/main.py", line 926, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "/opt/odoo/odoo11/odoo/api.py", line 687, in call_kw return call_kw_model(method, model, args, kwargs) File "/opt/odoo/odoo11/odoo/api.py", line 672, in call_kw_model result = method(recs, *args, *kwargs) File "/opt/odoo/odoo11/addons/hrms_dashboard/models/hrms_dashboard.py", line 239, in employee_leave_trend self.env.cr.execute(sql, (employee[0]['id'],)) File "/opt/odoo/odoo11/odoo/sql_db.py", line 155, in wrapper return f(self, args, **kwargs) File "/opt/odoo/odoo11/odoo/sql_db.py", line 232, in execute res = self._obj.execute(query, params) psycopg2.ProgrammingError: function expression in FROM cannot refer to other relations of same query level LINE 8: ... , generate_series(date_trunc('month', date_from:... ^

CybroOdoo / OpenHRMS

function expression in FROM cannot refer to other relations of same query level #16