2 Replies Latest reply on Mar 12, 2010 10:11 AM by WoodApple

    How to perform multiple search request in Filemaker 10

    mkroeker

      Title

      How to perform multiple search request in Filemaker 10

      Post

      Hi there,

       

      I'm using Filemaker 10, on Mac OSX 10.6.2.

       

      I'm trying to find the fastest way to perform the following search ...

       

      I have a database of 699,000 records, from across Canada and I would like to perform a search for the following cities in the CITY field.

       

       

      Acadia Valley Acme Alix Alliance Altario

      Amisk Bashaw Bawlf Big Valley Birchcliff Bittern Lake Blackfalds Bodo Botha Bruce Byemoor Cadogan Camrose Carbon Castor Cereal Champion Chauvin Chinook Clive Compeer Consort Coronation Craigmyle Czar Daysland Delburne Delia Denwood Donalda Drumheller Duchess East Coulee Edberg Edgerton Elnora Empress Endiang Erskine Esther Ferintosh Forestburg Gadsby Galahad

      Gem Gwynne Halfmoon Bay Halkirk Hanna Hardisty Hay Lakes Hayter Heisler Hobbema Holden Hughenden Hussar Huxley Irma Irricana Jarvis Bay Kathyrn Kelsey Keoma Killam Kingman Kinsella Kirriemuir Lacombe Lougheed Meeting Creek Metiskow Mirror Monitor Morrin Munson Nevis New Brigden New Norway Norglenwold Ohaton Oyen Paradise Valley Patricia Pine Lake Pollockville Ponoka Provost Ralston Red Deer Red Deer County Red Willow Rimbey

      Rivercourse Rockyford Rolly View Rosalind Rosebud Rosedale Station Rosedale Valley Round Hill Rowley

      Rumsey Ryley Sedalia Sedgewick Sibbald Spring Lake Springbrook St Brides Standard Stettler Strome Sunnynook Swalwell

      T ees Three Hills Tofield Torrington Trochu Veteran Viking Wainwright Wetaskiwin Wimborne Youngstown

       

       

       

      Is there a better way then having to create a new find request for each city?

       

       

      Thanks for the help  :)

        • 1. Re: How to perform multiple search request in Filemaker 10
          ninja

          Howdy,

           

          This is a "thinking out loud" post...not a "do this"...

           

          If you create two new fields in your table:

          SearchCriteria (global text field) and Applicable (unstored calculation)

           

          Applicable = Patterncount (City ; SearchCriteria)

           

          When you dump your list of cities into your global SearchCriteria field, the Applicable field will be greater than zero for those records that are...well...applicable.  Then do your search for >0 in the Applicable field.

           

          Again, just thinking out loud.  There may be an easier way.

          • 2. Re: How to perform multiple search request in Filemaker 10
            WoodApple

            Guess it kind of depends on how often you need to do this. (and who needs to do it)

            If this is a one time only thing, just do a find with whatever criteria you need(will be quicker than even thinking of another way)...

            If you need to do this search (or type of search) often, there are any number of ways to make this easier.


            Ninja wrote:

            ...

            If you create two new fields in your table:

            SearchCriteria (global text field) and Applicable (unstored calculation)

             

            Applicable = Patterncount (City ; SearchCriteria)

             

            This will work but the global and unstored calc will make this very slow. (but it should always work for any user in a multiuser environment and let them all have their own sets of cities)

            I would be more inclined to make the same two fields and leave the second one defined as a number (not a calc) and replace the value in all records with the calculation, redoing the replace when you choose to use a different set of cities. (will allow field to be indexed and that will make the find work faster but... Would only work for a single user unless all users wanted the same result) 

             

            There are other ways to do this as well.