Customize listview so that only submitted documents should appear

[Vinay1]

I want to customize the list view of salary slip so that only submitted salary slips should appear
i tried to add a filter but it is not working

frappe.listview_settings['Salary Slip'] = {
	
	add_fields: ["employee", "employee_name"],

	filters: [
		['status', '=', 'Submitted']
	],

	before_render() {
		console.log("in before_render of frappe.listview_settings['Salary Slip']");
        // triggers before every render of list records
		frappe.listview_settings['Salary Slip'].filters.push({
            fieldname: "status",
            operator: "=",
            value: "Submitted"
        });
    },
};

still all salary slips are being shown ie., salary slips in draft and submitted state

[NCP]

Hi @Vinay1,

Please check the references:

Reference:

How to apply filter for listview of doctype

frappe.call not work in frappe.listview_settings , for that use like this let user_l = []; frappe.call({ method: "demo_app.public.python.listview_all.user_filter", args: { doctype: doc }, }).then(function(r) { user_l.push(r.message); }); frappe.listview_settings['Purchase Invoice'] = { onload: function(r) { frappe.route_options = [] frappe.route_options = user_l[0] } };

How to set default filter in task doctype?

Hi @keerthana_2001, Please apply it. frappe.listview_settings['Task'] = { onload: function(listview) { frappe.route_options = { "is_milestone": ["=", 1] }; } }; Output: [image] Thank You!

Filter in Listview

Hi @Viktor_Kuhn, Please apply the listview client script for that. frappe.listview_settings['Sales Order'] = { onload: function(listview) { frappe.route_options = { "status": ["!=", "Completed"] }; } }; Here I applied the filter using the listview client script for Sales Orders and only showed the non-completed orders when you reload the sales order. Output: [image] I hope this helps. Thank You!

Listview filtering with created_by(User DocType) field

Hi @Umair_Mehmood, Please apply it. frappe.listview_settings['Project'] = { onload: function(listview) { frappe.route_options = { "owner": frappe.session.user }; } }; Then reload and check it. Thank You!

I hope this helps.

Thank You!

[Vinay1]

Thanks @NCP,
it worked,
i want to do this only to a particular role
this is how i done it

frappe.listview_settings['Salary Slip'] = {
	
	add_fields: ["employee", "employee_name", "status"],

	// filters: [
	// 	['status', '=', 'Submitted']
	// ],

	onload : function(listview) {
        
		console.log('user roles: ',frappe.user_roles);
		// Employee
		user_roles = frappe.user_roles
		
		if(!(user_roles.includes("Administrator"))){
			if (user_roles.includes("Employee")) {
				// "Employee" role exists in the array
				console.log("User has the 'Employee' role.");
				frappe.route_options = {
					"status": "Submitted"
				};
				$('.filter-selector').hide();
				listview.refresh();
			}
		}
    }
};

in above code, if the user has “Employee” and user is not “Administrator” then we will apply the filter and then hide the filter option from the UI

[kittiu]

Thanks for the Solution.

I have tested it OK. But it also result in another problem, i.e., when you click on Link Document in Connections.

For example, this connection should link to Employee’s Tax Declaration only (filter = this employee)

But with the preset default filter, it always route to the default filters