Search for Attribute Values and Abbreviations

chlarsen · March 11, 2016, 8:24am

Dear All,

I have created an item template with a fairly complex tree of variants, plus related abbreviations.
I noted that the system can perform an incremental search of Attribute Values (as long as I start with the right string), while substring searches are not supported.
Likewise, it does not seem to be able to identify Attribute Value Abbreviations I enter instead of the Attribute Value - a very handy feature, if I know the respective code (i.e. Abbreviation) by heart already.
I had a look at https://frappe.github.io/erpnext/user/manual/en/customize-erpnext/articles/search-record-by-specific-field.html and tried to follow the instructions, but none of the Attribute Value-related documents seem to permit searches.
Any thoughts or ideas?
Thanks a lot, indeed!

Chris

rmehta · March 11, 2016, 10:00am

@chlarsen Search fields are not honoured for the item query

github.com

frappe/erpnext/blob/develop/erpnext/controllers/queries.py#L158


      
          
          

          
@frappe.whitelist()
          @frappe.validate_and_sanitize_search_inputs
          def tax_account_query(doctype, txt, searchfield, start, page_len, filters):
          	doctype = "Account"
          	company_currency = erpnext.get_company_currency(filters.get("company"))
          
          
	def get_accounts(with_account_type_filter):
          		account_type_condition = ""
          		if with_account_type_filter:
          			account_type_condition = "AND account_type in %(account_types)s"
          
          
		accounts = frappe.db.sql(
          			"""
          			SELECT name, parent_account
          			FROM `tabAccount`
          			WHERE `tabAccount`.docstatus!=2
          				{account_type_condition}
          				AND is_group = 0
          				AND company = %(company)s

chlarsen · March 11, 2016, 10:18am

Yes, I realised it, because there is no way to add search items. Would it make sense to add this feature? I am currently adding item variants by copying/pasting between two browser windows. With the above search enabled, this could be much easier…
What’s your take?
Chris