Skip to main content

Use Wild Card searches on Alliance using Percent sign

  • June 28, 2021
  • 1 reply
  • 451 views

Forum|alt.badge.img+1

One way to improve search is to use the percent sign sign as a wild card. For example if you are looking for a product that starts with an M and ends in 01. you would enter M%01 in product id field to search for all like products.

1 reply

Forum|alt.badge.img+10

Just be mindful when using wildcard searches as using wildcards may take longer to process on the database, especially fields that are not indexed.  In larger databases, wildcard searches may present a problem in specific areas such as order and item locator search screens.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings