App Versions
{
"frappe": "16.0.0-dev",
"frappe_theme": "0.0.1",
"myojana": "0.0.1",
"sva_dashboard": "0.0.1"
}
Route
List/Children Profiling/List
Traceback
Traceback (most recent call last):
File "apps/frappe/frappe/app.py", line 114, in application
response = frappe.api.handle(request)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/api/__init__.py", line 49, in handle
data = endpoint(**arguments)
^^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/api/v1.py", line 36, in handle_rpc_call
return frappe.handler.handle()
^^^^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/handler.py", line 49, in handle
data = execute_cmd(cmd)
^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/handler.py", line 85, in execute_cmd
return frappe.call(method, **frappe.form_dict)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/__init__.py", line 1814, in call
return fn(*args, **newargs)
^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/utils/typing_validations.py", line 32, in wrapper
return func(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/__init__.py", line 963, in wrapper_fn
retval = fn(*args, **get_newargs(fn, kwargs))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/desk/reportview.py", line 32, in get
data = compress(execute(**args), args=args)
^^^^^^^^^^^^^^^
File "apps/frappe/frappe/desk/reportview.py", line 78, in execute
return DatabaseQuery(doctype).execute(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/model/db_query.py", line 193, in execute
result = self.build_and_run()
^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/model/db_query.py", line 234, in build_and_run
return frappe.db.sql(
^^^^^^^^^^^^^^
File "apps/frappe/frappe/database/postgres/database.py", line 230, in sql
return super().sql(modify_query(query), modify_values(values), *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/database/database.py", line 236, in sql
self._cursor.execute(query, values)
psycopg2.errors.AmbiguousColumn: column reference "modified" is ambiguous
LINE 1: ...ildren Profiling"."desired_class_enrollment", MAX(modified) ...
^
Request Data
{
"type": "POST",
"args": {
"doctype": "Children Profiling",
"fields": "[\"`tabChildren Profiling`.`name`\",\"`tabChildren Profiling`.`owner`\",\"`tabChildren Profiling`.`creation`\",\"`tabChildren Profiling`.`modified`\",\"`tabChildren Profiling`.`modified_by`\",\"`tabChildren Profiling`.`_user_tags`\",\"`tabChildren Profiling`.`_comments`\",\"`tabChildren Profiling`.`_assign`\",\"`tabChildren Profiling`.`_liked_by`\",\"`tabChildren Profiling`.`docstatus`\",\"`tabChildren Profiling`.`idx`\",\"`tabChildren Profiling`.`name_of_the_child`\",\"`tabChildren Profiling`.`age`\",\"`tabChildren Profiling`.`family_phone_number`\",\"`tabChildren Profiling`.`desired_class_enrollment`\"]",
"filters": "[[\"Child Follow Up\",\"conversion_and_follow_up\",\"=\",\"Pending\"]]",
"order_by": "`tabChildren Profiling`.modified desc",
"start": 0,
"page_length": 20,
"view": "List",
"group_by": "`tabChildren Profiling`.`name`",
"with_comment_count": 1
},
"freeze": false,
"freeze_message": "Loading...",
"headers": {},
"error_handlers": {},
"url": "/api/method/frappe.desk.reportview.get",
"request_id": null
}
Response Data
{
"exception": "",
"exc_type": "AmbiguousColumn",
"_debug_messages": "[\"Error in query:\\ncolumn reference \\\"modified\\\" is ambiguous\\nLINE 1: ...ildren Profiling\\\".\\\"desired_class_enrollment\\\", MAX(modified) ...\\n ^\\n\"]"
}
I hope this error is comming from here