Auto-Complete Settings

SUGGESTED

Does anyone know if there's a way to change the Auto-Complete setting to "contains" instead of "begins with" in Sage 100 ERP 2014 v. 5.10.4.0?  I don't see anything in System Configuration or User Maintenance.  It would be most useful in item lookup.  Many of our item descriptions contain colors and with over 17,000 SKUs...when you enter "brown" for example, auto-complete returns 7 items.  When you do a look up "description, contains, brown" the user gets 167 items.  Thanks!

Parents
  • 0

    Pretty sure the answer is no.

    When doing the auto-complete speed would be very important and a name contains search can't really use indexes for speed whereas a begins with search can.  The search would essentially become a linear search and with 17,000 items it would probably be painfully slow (it would have to search again after each character typed).

    So if you need a names contains search you will have to rely on good ol'  F2.

    Some one correct me if you have better information,  because I would love to have it be able to use a name contains too.

Reply
  • 0

    Pretty sure the answer is no.

    When doing the auto-complete speed would be very important and a name contains search can't really use indexes for speed whereas a begins with search can.  The search would essentially become a linear search and with 17,000 items it would probably be painfully slow (it would have to search again after each character typed).

    So if you need a names contains search you will have to rely on good ol'  F2.

    Some one correct me if you have better information,  because I would love to have it be able to use a name contains too.

Children