Search all records

[Yellow]

Please forgive me if this has already been addressed, but I can't seem to find the answer to my question anywhere.

I have a simple image database which needs to be searchable by keyword (like your standard search engine). Is there a way to enter keywords into a single dedicated search field and perform a find which will search all fields and return all records that match the search term(s) in any field?

thanks,

Jenn.

[Lee Smith]

The way I would do this is OLD, so there may be a new and improved way for 7, 8, and or 8.5.

You would want to create a calculation filed and Concatenate the key fields (See Online Help under either Concatenate or Text Operators).

Field1 & Field2 & field3

and so on.l

HTH

Lee

Edited October 27, 2006 by Guest
clean up

[John Mark Osborne]

There are a couple of ways to approach this task.

1. You could create a calculation that concatenates all of the fields you want to search. Spaces should be concantenated between each field so indexing on the calculation works properly. The advantage with this technique is it is easy to implement and can be used manually. However, if you have a lot of fields, you are duplicating the data twice.

2. You could create a script that copies a values from a Show Custom Dialog script step with the option for an input field. The input field would be a global field which you could then transfer the contents to multiple fields on multiple New Requests. The advantage of this technique is you get to use the existing fields for searching. On the other hand, the scripting is a little more involved and requires a script.