Part description search - Printable Version +- webERP Forum (http://www.weberp.org/forum) +-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1) +--- Forum: Problems / Bugs? (http://www.weberp.org/forum/forumdisplay.php?fid=8) +--- Thread: Part description search (/showthread.php?tid=8391) |
Part description search - alanmi3833 - 03-20-2020 Good day When I search for a string in the part partial description, nothing gets returned. Are my search parameters wrong? Eg. When I search for 1N5374 in partial description, which contains ZENER 5W 75V 1N5374 I get Quote:INFORMATION Message : No stock items were returned by this search please re-enter alternative criteria to try again Just realized it searches in part description short not long. Are there a way to search in long part description, as there are so much more information there. Most of the time in short are only an excerpt from the long. RE: Part description search - TimSchofield - 03-20-2020 This is quite easy to do in individual scripts, though parts are searched for in many scripts, so changing them all would take some time. For instance in SelectProduct.php change line 607 from AND stockmaster.description " . LIKE . " '$SearchString' to AND stockmaster.longdescription " . LIKE . " '$SearchString' and line 627 from WHERE description " . LIKE . " '$SearchString' to WHERE longdescription " . LIKE . " '$SearchString' You can change any other scripts you like in a similar fashion. The question is, whether this should be policy, and we change all scripts, or should we leave it as is? Thanks Tim RE: Part description search - TurboPT - 03-20-2020 I'll take a look at the various part search areas too, curious if we might be able to streamline those areas to have common handling. A couple of ideas that come to mind: 1. Could we also OR the two fields within the search maybe? 2. An option (such as a checkbox) with part searches to include long descriptions? I'm open to other ideas as well. RE: Part description search - TimSchofield - 03-21-2020 Hi Paul, personally I prefer the first option. Maybe this is the time to revisit the idea of having the item search code taken out into a separate include script so that we can have the same search code used throughout weberp? This would allow us to be more sophisticated in our search technique, using Soundex for example. Needs careful thought on the design of this script though. Tim RE: Part description search - TurboPT - 03-21-2020 Tim, Yes, that is exactly my idea too with the '...streamline those areas to have common handling', so I feel we are on the same page! (though likely not expressed in the same way) RE: Part description search - alanmi3833 - 03-23-2020 Thank you so much Tim. Changed to: Code: AND (stockmaster.longdescription " . LIKE . " '$SearchString' Regards Alan |