I have written a Vortex script that allows my customers to search a Vortex database. The problem I am having is when my users search for things like "T-72".
They will get the results for "T-72" but not results for "T72" or "T 72". All of these are good hits.
If I write the query as '/T=-?"72"=' I can get all of these returns, but the search takes a long time to run. I would also have difficulty trying to get people to use this syntax.
I am using "<sql "set addexp = '[\alnum\/\-]{2,99}'"></sql>" for my word definition. Should this be changed to something else or is there a better way to handle this type of query?
They will get the results for "T-72" but not results for "T72" or "T 72". All of these are good hits.
If I write the query as '/T=-?"72"=' I can get all of these returns, but the search takes a long time to run. I would also have difficulty trying to get people to use this syntax.
I am using "<sql "set addexp = '[\alnum\/\-]{2,99}'"></sql>" for my word definition. Should this be changed to something else or is there a better way to handle this type of query?