I have a doctype school_year and class. And class belongs to school_year. In the report filter class should be filter base in what school_year is selected. How can I filter the class base on school_year value?
this is my current js.
frappe.query_reports["Subject Grading Report"] = {
"filters": [
{
"fieldname": "school_year",
"label": __("School Year"),
"fieldtype": "Link",
"options": "School Year",
"default": frappe.defaults.get_user_default("School Year"),
"reqd": 1
},
{
"fieldname": "class",
"label": __("Class"),
"fieldtype": "Link",
"options": "Class",
"reqd": 1
}
]
}