"Live" search query

[Greg Hains]

Hi,

I have a script screendump (attached in PDF format), that I have put together (with the help of others admittedly...), and have been trying to achieve an extra step, but to date been unsuccessful

Those of you who do look at it will see that it allows me to do a realtime search across four fields. One of the fields I choose to search on (as marked with red markers in the script)appears to be completely ignored - that is, the first three fields criteria is successfully met, but not the marked one. I have tried chaging the order etc but makes no difference. It must be something I am doing wrong.

Can anybody please point me in the right direction.

Cheers,

Greg

GlobalSearch.pdf

[Ocean West]

For starters ---

Use this logic for your iteration ...

you then can remove the last Set variable for $i at the end of the stack along with the last exit loop if.

Exit Loop If [ Let ( $i = $i + 1 ; $i > ValueCount ( $searchList ) or Get(FoundCount) = 0 ) ]

And I don't think you need that last New Record/Request.

the way i am reading this ( sorry i am caffeine deprived ) -

You have a list of values, return list of strings

you want to see all records that match items in the string

Internal Job Number OR Client Company OR Client Contact OR Job Status of Open...

Are you trying to restrict it so that ONLY open records are displayed?

that would be an AND condition.

if so try and copy the set field for the job list and put it just above the other New Records/Request steps

So it would be:

Job Num=$thisTerm AND Status = Open OR

Company = $thisTerm AND Status = OPEN OR

Contact = $thisTerm AND Status = OPEN

====

Here is another option = see attachment.