commit 2b986d3b0245275007d09c8898783cdaf50ab333
author Nabin Hait <nabinhait@gmail.com> Wed Jan 20 13:11:44 2016 +0530
committer Nabin Hait <nabinhait@gmail.com> Wed Jan 20 13:11:44 2016 +0530
tree d839abb4eb7dd43f7a0fb9b6f010ee900318273b
parent 7633aca7c1e1dec89e4d9f3752052b82e47fe1ee
parent 3fb5340188cc84a27308049fe7b526bb00cfe224

Merge pull request #4651 from RicardoJohann/patch-4

Update queries.py - Added item_group

erpnext/controllers/queries.py

diff --git a/erpnext/controllers/queries.py b/erpnext/controllers/queries.py
index 3c262f1..ca431ce 100644
--- a/erpnext/controllers/queries.py
+++ b/erpnext/controllers/queries.py
@@ -158,7 +158,7 @@
 def item_query(doctype, txt, searchfield, start, page_len, filters):
 	conditions = []
 
-	return frappe.db.sql("""select tabItem.name,
+	return frappe.db.sql("""select tabItem.name,tabItem.item_group,
 		if(length(tabItem.item_name) > 40,
 			concat(substr(tabItem.item_name, 1, 40), "..."), item_name) as item_name,
 		if(length(tabItem.description) > 40, \