Item Code Query Listing

In Material Request > Item Code Query, I would like to add in search listing one more item i.e the Default Warehouse (default_warehouse in item table). The default query as per listed includes: Item Group, Item Name and Description.

How this will be possible?

Answering my own post, I found this server side customization by adding “tabItem.default_warehouse” on line 160 of queries.py in directory controllers.

return frappe.db.sql(“”"select tabItem.name, tabItem.item_group, tabItem.default_warehouse,

Cheers!