App Versions
{
"erpnext": "16.0.0-dev",
"frappe": "16.0.0-dev",
"library_tut": "0.0.1"
}
Route
List/User/List
Traceback
Traceback (most recent call last):
File "apps/frappe/frappe/app.py", line 117, 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 50, in handle
data = execute_cmd(cmd)
^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/handler.py", line 86, in execute_cmd
return frappe.call(method, **frappe.form_dict)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/__init__.py", line 1727, 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 867, 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 209, in execute
result = self.build_and_run()
^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/model/db_query.py", line 250, in build_and_run
return frappe.db.sql(
^^^^^^^^^^^^^^
File "apps/frappe/frappe/database/postgres/database.py", line 233, in sql
return super().sql(modify_query(query), modify_values(values), *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "apps/frappe/frappe/database/database.py", line 238, in sql
self._cursor.execute(query, values)
psycopg2.errors.AmbiguousColumn: column reference "creation" is ambiguous
LINE 1: ... "tabUser"."user_image", "tabUser"."enabled", MAX(creation) ...
^
Request Data
{
"type": "POST",
"args": {
"doctype": "User",
"fields": "[\"`tabUser`.`name`\",\"`tabUser`.`owner`\",\"`tabUser`.`creation`\",\"`tabUser`.`modified`\",\"`tabUser`.`modified_by`\",\"`tabUser`.`_user_tags`\",\"`tabUser`.`_comments`\",\"`tabUser`.`_assign`\",\"`tabUser`.`_liked_by`\",\"`tabUser`.`docstatus`\",\"`tabUser`.`idx`\",\"`tabUser`.`user_type`\",\"`tabUser`.`full_name`\",\"`tabUser`.`user_image`\",\"`tabUser`.`enabled`\"]",
"filters": "[[\"User Role Profile\",\"role_profile\",\"=\",\"member\"]]",
"order_by": "`tabUser`.creation desc",
"start": 0,
"page_length": 20,
"view": "List",
"group_by": "`tabUser`.`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 \\\"creation\\\" is ambiguous\\nLINE 1: ... \\\"tabUser\\\".\\\"user_image\\\", \\\"tabUser\\\".\\\"enabled\\\", MAX(creation) ...\\n ^\\n\"]"
}
I didn’t add any fields to users so I don’t get why the stock creation field is an issue.