Jump to content

8.0v2 Changes to Searching


mav
 Share

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

Recommended Posts

I've looked at a similar thread (172736) pointing out the change in FileMaker 8.0v2 where searches are now performed from the local cache, rather than from the host.

APPLICABLE TO:

FileMaker Pro 8.0v2, FileMaker Pro 8.0v2 Advanced

Mac OS X

ISSUE:

Performing finds on a hosted file that contains unstored calculation fields can result in a larger local temp file.

EXPLANATION:

In FileMaker Pro 7 and FileMaker Pro 8.0v1, all finds on unstored calculation fields were sent to the host.

This was an issue with certain unstored calculations such as calculations that use a Get(StatusAreaState) or something else that must be done locally. Unfortunately, in some more complex cases, the calculation could not run correctly on the host, and the field became unsearchable.

To resolve this, In FileMaker Pro 8.0v2 all unstored finds are now performed locally, which will result in more records being cached in the local temp file.

This applies to FileMaker Pro 8.0v2 with either FileMaker Server 7 or FileMaker Server 8.

The time it now takes to perform the search in the unstored fields is noticeably slower.

The field being searched is a calculation (therefore unstored) of a number of fields that make up the Company + Clients records.

Searching this calculation field allows users to enter a text string and search any of the 20 related fields.

I've attached a small sample to show how my file is constructed.

I want to be able to index this search field, to speed up the searches, but at the same time ensure the users are getting up to date data . . .

Thanks in advance

search.zip

Link to comment
Share on other sites

It shouldn't be too hard to make your search on indexable fields alone (see also this thread).

In broad terms, do your search in the Companies table first (using only local fields).

If you find anything, GTRR in Clients (Show related only, Match found set), and do a search there extending the found set.

If you haven't found anything in Companies, move to Clients and do a search there.

Link to comment
Share on other sites

thanks for the tip . . .

I think I've used the wrong method to by-pass the dialog where there are no records in the first find, as now if there are no records from either search I am presented with the same records I was browsing (before the search) and no feedback that the search does not find any records.

Is there a better way to skip the 'no records' found dialog after the first find ?

search2.zip

Link to comment
Share on other sites

I didn't check your script thoroughly (I did notice you're checking for total records instead of found).

I am attaching a template that does more or less what I suggested. It still needs some work, though. You might consider doing all this in another window, where you can present the found records in a list, while still keeping the original found sets - in case nothing is found.

search.fp7.zip

Link to comment
Share on other sites

Thanks again for your help Comment.

I've looked at what you have built, and can see what you are suggesting, and the changes I would need to make to the user experience, to get a similar result before the 8.0v2 update.

To keep the same 'simple' user experience, I have scripted the copying and updating of the Company records to new fields in the related Client records, to allow for the searches to be in indexed fields.

It's a pity FileMaker would make such a change to un-indexed searching, it seems such a 'band aid' solution . . .

Link to comment
Share on other sites

This topic is 5717 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

  • Similar Content

    • By Tumma K
      Hello, All!

      I am an aspiring developer for Filemaker. The company I work with is stuck in the past working off of Filemaker Pro 4.1

      I was given the task of bringing us up to Filemaker Pro/Server 13. So far my conversion prototypes are successful but we recently had a layout issue that can only be fixed in versions 3-6 (as the file is an .fp3) I work off of a macbook while our network is all Windows 7. In order for me to repair the layouts without tampering our active database, I decided the best option is to repair a copy of our solutions off the network. Unfortunately, when I go to download the trial version of Filemaker Pro 6 off of the respected website, the file is corrupt! I've tried multiple times, with different extraction apps and in different directories.

      My question is;

      Does anyone know a place where I could obtain version 6 (or better yet, 4.0) for an OSX computer? I've looked everywhere!
       
      Thank you for your time,
      Tumma K.
    • By MrEddByrnes
      I'm hoping my question can have a happy ending. In the mid-90's, I purchased Filemaker 3. When Filemaker 5.5 Pro was released, I bought the update CD, which requires the user to either have FM 3 installed or to have the installation CD for FM 3. I've used it all these years, most recently with Windows XP Pro, and it has worked just fine. The databases I began with were long ago converted to FM Pro 5.5 databases.
       
      I'm still using FM Pro 5.5 on a laptop with WinXP Pro, but in 2013, I purchased a PC with Windows 8. I haven't been able to install FM 3 on it, therefore can't install FM Pro 5.5. I am retired and rarely use Filemaker, but I have a few Filemaker databases I'd like to add to my Win 8 machine. I don't feel it's worth upgrading FM for the sake of using a couple of databases.
       
      Has anyone else run into this situation and/or have a (possible) solution? Is there perhaps any other software that can read FM 5.5 databases? Thanks in advance for your help.
       
    • By bmill
      I am using a custom filemaker solution for medical office billing written with fp5 running on a mac with snow leopard. In addition, I have a patient management db (which I wrote) that is linked through pt. ID number to the billing program allowing transfer of some demographic information (name, DOB, etc).
       
      Other than being limited by hardware restrictions, the billing program serves our needs for now and upgrading to fp12 will take some time (and money).  In the meantime, I am upgrading my pt. management program to fp13 and would like to move new patient demographic information from the billing program ( fp5 running on snow leopard through Parallels) and the new pt management program ( fp13 running on OS X 10.9) on the same mac.   
       
      Ideally, demographic information would be entered once into fp5 and then a scipt would make the data available for fp13.
       
      Any ideas on how to make this work?
    • By randyinla
      Hi, can anyone tell me why my on-line database might have stopped allowing me to delete records?  All of my access privileges and passwords are correct.
       
      thanks!
    • By randyinla
      Hi, I still use filemaker 5.5 and am very happy with it and don't want to upgrade.  Does anyone still host filemaker 5.5?  Thanks!
×
×
  • Create New...

Important Information

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