How to select parent warehouse in query report?

ERPNext Reports
1

Hi Guys ,

I am preparing a query report in which I should select the parent warehouse ? But only the child warehouses are visible . How to achieve this ?

Thanks

2

Define qet_query while creating filters

{
	"fieldname":"warehouse",
	"label": __("Warehouse"),
	"fieldtype": "Link",
	"options": "Warehouse",
	"get_query": function() {
		return {
			"filters": [
				['Warehouse', 'is_group', 'in',  [0, 1]],
			]
		}
	}
}
3 Likes
3

Many thanks for the info @saurabh6790 . But how to achieve this in query report ?

Thanks