Page 1 of 1

Turn off Iterative Search for one Table?

PostPosted: Thu Oct 11, 2012 1:54 am
by DPmax
I have one table (Table03 to be exact) where I'd only want to find (for example) John Doe... I would not want John Smith or Jane Doe or even Johnny Doe in the results.
I do not want my users to be required to put in search modifiers like = or ==
The fields searched in the Table03 are
NameFirst
NameMiddle
NameLast

Any assistance is always appreciated

Thanks,
Max

Re: Turn off Iterative Search for one Table?

PostPosted: Thu Oct 11, 2012 9:15 am
by JasonYoung
Hi,

In the script "Search - Iterate" there is an IF clause that begins with the comment

#If data type is text or list, build array of search terms and try them all

This is the part that breaks the search string into individual words to use as criteria. If you disable the whole IF block, then that will prevent that part from happening.

hth,
Jason