Jump to content

Keyword Search


Donna
 Share

This topic is 7769 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Is there anyway to get FileMaker Pro to search every field in every related database for a term/word? It is something I have been able to do with other database programs and need to be able to do with FileMaker.

Has anyone done this kind of thing successfully?

Link to comment
Share on other sites

quote:

Originally posted by Donna:

Is there anyway to get FileMaker Pro to search every field in every related database for a term/word? It is something I have been able to do with other database programs and need to be able to do with FileMaker.

Has anyone done this kind of thing successfully?

This is possible, but would need to be explicitly scripted.

Now, there might be a plugin that allows this kind of thing.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Senior Filemaker Developer

http://www.inthescene.com

mailto:[email protected]

=-=-=-=-=-=-=-=-=-=-=-=-=

Link to comment
Share on other sites

quote:

Originally posted by [email protected]:

I've only just started using this program, so I don't very much. Have you tried making an additional calculation field in your database that combines all of the fields you want to search into that field? I don't know if this would make your records much larger or not if it is a calculation. Anyway, that should work. Does anybody know what that would do to a record size?

This method would efficively double the size of each record. However Filemaker only indexes the first 20 characters of a field, so everything after that would be wasted.

I would simply set up a script that performs a series of finds, checking to see if the resultant found set is what you are looking for and if so, halt the script.

The very first thing that I might suggest however is to refine your design and revisit why you need to perform this kind of search. My guess is that this is NOT actually needed and the same ultimate goal can be accomplished with MUCH less work and maintainence.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Senior Filemaker Developer

http://www.database-resources.com

mailto:[email protected]

=-=-=-=-=-=-=-=-=-=-=-=-=

Link to comment
Share on other sites

Create a global field, called "searchword".

Script a find as follows:

copy[searchword]

enter find mode

paste [field1]

new record/request/page

paste [field2]

new record/request/page

paste [field3]

etc. etc. through all fields

perform find

et voila

HTH

Dan

Link to comment
Share on other sites

I've only just started using this program, so I don't very much. Have you tried making an additional calculation field in your database that combines all of the fields you want to search into that field? I don't know if this would make your records much larger or not if it is a calculation. Anyway, that should work. Does anybody know what that would do to a record size?

Link to comment
Share on other sites

Thanks for your replies. I knew that the calculation field option was not an option owing mostly to the fact that my records will be quite large.

I DO in fact require this field as I am designing a searchable database for archival descriptions and if it is not possible to search for a term that could conceivably appear in anyone of say ten fields in anyone of ten tables, I am not offering a very searchable option.

Given this info, has anyone done something similar? In other words, the search is performed in a number of fields in a number of tables and then only the relevant part of the hierarchy is displayed to the user.

Link to comment
Share on other sites

This topic is 7769 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.