#1034 Google like search for i.e., Product

[KittiU]

A prospect customer come to me and said that his challenge is to find the the product in his inventory. For example, he only know that the product contain the word, "white" and "black" but he is not sure it is the name or the value or even the attribute of the product. With current search screen, he will have try all possible combination of columns.

It will be much more efficient if he can only type in these word in one generic search box and it goes to lookup for all columns, i.e., similar to Google.

I have found an interesting feature about full text search of Postgresql http://www.postgresql.org/docs/8.3/static/textsearch-intro.html

May be it can be used to enhance the search functionality of ADempiere. For example, in Product Info Form. Add another generic field that search for all criteria, i.e., Key, Name, Desc, Attributes, SKU, Product Category, etc.

Or if it works, create a new generic search window, that will search for everything in database. The result group by type, i.e., Product (6 results), BPartner (3 results), etc. User can then Zoom to the each result to that record.

[Heng Sin]

For full text search, this could be one of the options - http://code.google.com/p/lusql/

[Marcelo Luiz Onhate]

At first this need to be done...
http://sourceforge.net/tracker/index.php?func=detail&aid=3110868&group_id=176962&atid=879335

[mckayERP]

Hi KittiU,

The updates to the lookups in Feature/ADEMPIERE-72 do some of this. Wild cards can be used in the Product fields and the field will search the value, name, SKU and UPC fields for a match. In the info window, it is possible to search for all products that use a specific product so you could ask for all products that are "black".

Mike.