List View filter

[Swathi_Shiragaddi]

I have a doctype where the records are displayed in list view according to the conditions i have written in server side script, Example i have a doctype where i am fetching the records according to the query and displaying them in the front end

now when i try to filter the record

it is not filtering, can anyone tell me what might be the issue

[NCP]

Hi @Swathi_Shiragaddi,

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!

Thank You!

[Swathi_Shiragaddi]

see basically this code
frappe.listview_settings[‘Fimer Post Training Evaluation Form Test’] = {
refresh: function(listview) {
frappe.call({
method: ‘hrms.hr.doctype.fimer_post_training_evaluation_form_test.custom.get_evaluation_forms_for_user’,
callback: function(response) {
if (response.message && response.message.forms) {
var forms = response.message.forms;
var count = response.message.count;
listview.page.wrapper.find(‘.list-count’).text(${count} of ${count});
listview.data = forms;
listview.render();
listview.page.wrapper.find(‘.list-pagination’).css(‘display’, ‘none’);
} else {
listview.page.wrapper.find(‘.result’).html(“

No forms available.

”);
}
},
error: function(xhr, textStatus, error) {
console.error(“Error fetching forms:”, error);
listview.page.wrapper.find(‘.result’).html(“

Error fetching evaluation forms.

”);
}
});
}
};

import frappe

@frappe.whitelist()
def get_evaluation_forms_for_user():
session_user = frappe.session.user
if session_user == ‘divya.j.ext@fimer.com’ or session_user == ‘Administrator’:
# If the user is hr@gmail.com, fetch all records
forms = frappe.db.sql(“”"
SELECT * FROM tabFimer Post Training Evaluation Form Test
“”“, as_dict=True)
else:
# For other users, fetch records based on ownership or reporting
forms = frappe.db.sql(”“”
SELECT * FROM tabFimer Post Training Evaluation Form Test
WHERE owner = %s OR reports_to = %s
“”", (session_user, session_user), as_dict=True)

 # Get the count of forms
count = len(forms)

return {
    "forms": forms,
    "count": count
}

is giving me exact records as requirement in my list view but

but for this code

this filter is not working , can anyone tell me why? in this two records the if i try to filter trainer name it is showing me all the two fetched records and for the code you gave it is not displaying any record, can you check again