Need to simulate filter in User showing only applicable records of frappe.session.user

jeffbangquil · December 24, 2016, 12:51pm

Hi,

I am currently creating a doctype that should only show records where name is equal to frappe.session.user.

I have checked on user_list.js with the listview_setting but could not find out how to do such.

Many thanks.

makarand_b · December 26, 2016, 5:34am

You will need to set the filters attribute in listview_settings. please check the user_list.js for the same.
e.g.
filters: [[“fielname”, “operator”, “value”]]

github.com

frappe/frappe/blob/develop/frappe/core/doctype/user/user_list.js#L6


      
          // Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors
          // MIT License. See license.txt
          
          
frappe.listview_settings["User"] = {
          	add_fields: ["enabled", "user_type", "user_image"],
          	filters: [["enabled", "=", 1]],
          	prepare_data: function (data) {
          		data["user_for_avatar"] = data["name"];
          	},
          	get_indicator: function (doc) {
          		if (doc.enabled) {
          			return [__("Active"), "green", "enabled,=,1"];
          		} else {
          			return [__("Disabled"), "grey", "enabled,=,0"];
          		}
          	},

Thanks, Makarand

jeffbangquil · December 26, 2016, 6:15am

The problem with that is the filter can be deleted by the user. The User do not show other user records to other users, unless it is a System Manager or Administrator.

felix · December 26, 2016, 7:09am

You will want to use role permissions to accomplish this.

https://frappe.github.io/erpnext/user/manual/en/setting-up/users-and-permissions/role-based-permissions

Make sure you check “Apply User Permissions” on the doctype and make sure the User Doctype is selected in “Select Document Types”.

Also, make sure “Set User Permissions” is checked for the User doctype.

aakvatech · June 10, 2018, 4:09pm

Found this useful. 2 follow up questions:

Is this available for group level as well, i.e. if the records is to be available for specific group and so all users within that group is allowed to view the records.
If the Doctype was “Child table” then how would the permissions be allowed to be set?

felix · June 11, 2018, 11:13am

This is possible if you have the group as a Linked Field in the doctype you are trying to filter. If not, then it’s not possible without customization.
You can’t do permissions on Child tables/doctypes.

aakvatech · June 11, 2018, 6:18pm

Is there an example in ERPNext that I can see and learn? I can’t figure out where it could be.

felix · June 12, 2018, 3:41pm

User Permissions is what you’re looking for: https://erpnext.org/docs/user/manual/en/setting-up/users-and-permissions/user-permissions.html