Set filter default to item from get_query in Script Report

Frappe Framework Customization
1

For a script report, I’m using get_query to get the list of Employees based on Company filter.
How can I set a default value for the EMployees filter from the result of get_query?
If suppose get_query returned 5 items, I would like to set default value to the first element in the returned list. Any help will be much appreciated. Thanks

2

Hi
You can do like follwing:
frappe.query_reports[“Employee Report”] = {
“filters”: [
{
fieldname: “employee”,
label: __(“Employee”),
fieldtype: “Link”,
options: “Employee”,
get_query: function(){
return {
filters: [
[‘Employee’,‘company’, ‘=’, ‘abc’]
]
}
},
default: ‘here write default employee name’
},
]
}