8 Replies Latest reply on Jul 3, 2009 12:12 PM by ww

    Constrain a found set?????

    ww

      Title

      Constrain a found set?????

      Post

      I have created a found set focused on 2 states, that have multiple cities. I would like to narrow it down some more by removing some of the city listing (which is a short list than the ones I want to keep, and have not been able to figure out what the next steps are to achieved the desired result.

       

       

       

      Help 

        • 1. Re: Constrain a found set?????
          mrvodka
            

          Try contraining the found set with omit requests.

           

          Enter Find Mode [ ]

          Set Field [ State; "FL" ]

          Set Field [ City; "Miami" ]

          Omit Record

          Duplicate Record

          Set Field [ State; "OH" ]

          Set Field [ City; "Dayton" ]

          Constrain Found Set []

           

           

          This will omit Miami, FL and Dayton, OH but NOT Miami, Ohio.

           

           

           

           

          • 2. Re: Constrain a found set?????
            ww
              

            @mr_Voka 

             

            I neglected to say I am a novice at this. 

             

            From what I can ascertain the procedure as:

             

            I enter the find mode

             

            In the state field I enter "FL"

             

            I click on new request and in the city field enter "Miami"

             

            Here's where I am lost, I am in filemaker 10. I cannot find an "Omit Record" or a "Duplicate Record" 

             

            There is a "duplicate request" and "delete request" under Requests. I am concerned about trying these as I might lose some data.

             

            If this isn't what you meant, could you clarify for a newbie?

             

            thanks

             

             

            • 3. Re: Constrain a found set?????
              mrvodka
                

              What I gave you was a script. If you are doing this manually then...

               

              1. Go into Find Mode

              2. In the State Field, enter:  FL

              3. In the City Field, enter:  Miami

              4. In the status toolbar, click the Omit button ( next to the Include button )

              5. Go to the Requests at the top of the screen and choose Duplicate Request

              6. In the State Field, change FL to:  OH

              7. In the City Field, change Miami to:  Dayton

              8. Go to the Requests at the top of the screen and choose Constrain Found Set

               

               

              • 4. Re: Constrain a found set?????
                ww
                  

                The manual procedure works but would be a monthly tedious task to do as I have about 30 cities I need to remove from the constrained found set. And for the life of me I have been struggling since yesterday with trying make the script route work.

                 

                I'm not sure if I had outlined the script I created so far, if it would have altered your suggestion or not.

                 

                Presently the data base is 550 strong and I created a script that narrows it down to just the entries in Oregon and Washington that have email addresses which consists of:

                 

                Perform Find with * in the email column

                Constrain Found Set with two Find Records "State" OR and WA

                giving me a Constrained set of 145 entries

                 

                 

                I have tried you suggestions to the letter with no luck. 

                 

                And after reading the manual I tried this

                 

                continuing on with the constrained set script and adding:

                 

                Enter Find Mode

                Omit Record

                Set Field [State; "WA"]

                Set Field [City; "Pullman"]

                Set Field [City; "Seattle"]

                Set Field [City; "Ocean Park"]

                 

                Now if I end it with Perform Find I end up with no entries just the find window

                 

                if I end it with Constrain Found Set I still end up with the find window with no entries.

                 

                Can you tell me what I am doing wrong?

                 

                 

                 

                • 5. Re: Constrain a found set?????
                  mrvodka
                    

                  ww wrote:

                  Perform Find with * in the email column

                  Constrain Found Set with two Find Records "State" OR and WA

                  giving me a Constrained set of 145 entries

                   


                   

                  You can just do a find for * in the email column and OR in the state. Duplicate the find request and change OR to WA. Then perform Find. You dont need a constrain for you first found set.

                   

                   

                   


                  ww wrote:

                  And after reading the manual I tried this

                   

                  continuing on with the constrained set script and adding:

                   

                  Enter Find Mode

                  Omit Record

                  Set Field [State; "WA"]

                  Set Field [City; "Pullman"]

                  Set Field [City; "Seattle"]

                  Set Field [City; "Ocean Park"]

                   

                  Now if I end it with Perform Find I end up with no entries just the find window

                   

                  if I end it with Constrain Found Set I still end up with the find window with no entries.

                   

                  Can you tell me what I am doing wrong?

                   

                   

                   


                   What you are doing here is entering find mode, setting it for Omit, setting the state to WA, setting the city to pullman, then overriding pullman to Seattle, overridng Seattle to OceanPark, and finally constraining your found set. So in the end, you are only fidning records that are in Ocean Park, WA. 

                   

                  Try this instead:

                   

                  Enter Find Mode

                  Omit Record

                  Set Field [State; "WA"]

                  Set Field [City; "Pullman"]

                  // duplicates find request and replaces Pullman with Seattle

                  Duplicate Record

                  Set Field [City; "Seattle"]

                  // duplicates find request and replaces Seattle with Ocean Park

                  Duplicate Record

                  Set Field [City; "Ocean Park"]

                  Constrain Found Set []

                   

                  This constrains the found set. to:

                   

                  Pullman, WA 

                  OR

                  Seattle, WA

                  OR

                  Ocean Park, WA 

                   

                   

                   

                   

                   

                   

                   

                   

                   

                   

                   

                   



                  • 6. Re: Constrain a found set?????
                    ww
                      

                    Boy I am so dense

                     


                    You can just do a find for * in the email column and OR in the state. Duplicate the find request and change OR to WA. Then perform Find. You dont need a constrain for you first found set.

                     

                    In manage scripts/Edit Script "Test" / Perform Find [Restore] / Specify Find Request

                     

                    i cannot seem to set it up the way you suggest. I can create a Find Records and enter and in the Specify Find Requests window enter in and email and only one state. If I then duplicate that Perform Find [Restore] I have to delete the email and change the state. Which gives me a result that includes alot of none email entries and states I do not want.

                     

                    If I create three seperate Perform Find [Restore] in the Edit Script Window like:

                     

                    Find Records Contacts::Email [*]

                    Find Records Contacts::State: [OR]

                    Find Records Contacts::State: [WA] 

                     

                    I get escentially the same result as above

                    I cannot with the rest of you suggestion as the only way I get the list close to what I want is 


                    Perform Find with * in the email column

                    Constrain Found Set with two Find Records "State" OR and WA

                    giving me a Constrained set of 145 entries


                     Which I now need to narrow some more by omitting some cities

                     

                    I really appreciate spending so much time on this with me. 

                    • 7. Re: Constrain a found set?????
                      mrvodka
                        

                      If you notice, my Enter Find Mode [ ] does not have a restore. I seldon use the restore option as I do not like explicitly stating the find criteria.

                       

                       

                      • 8. Re: Constrain a found set?????
                        ww
                          

                        This is and continues to be a struggle. I really appreciate your ongoing support.

                         

                        I did notice your Enter Find Mode was different than mine. I thought it was because we had different versions of filemaker.

                         

                        I cannot figure out how to get my script like yours.

                         

                        It appears in your directions that I should be able to find a script in this window that is has a simple name of "find" yet I cannot locate it.

                         

                        You can just do a find for * in the email column and OR in the state. Duplicate the find request and change OR to WA. Then perform Find. You dont need a constrain for you first found set.

                         

                         

                        I used the script in edit script window under category/name using the only find I can "Perform Find" and it appears by what you indicated above I need to specify within that find the email and state in one field and the second state in another much like the way a find works in the table view. Yet the minute I specify anything within the Perform Find and click "OK" it appends "restore" to its name. 

                         

                        I really appreciate your continued help, and I understand if you are as burnt out over this as I am and want it to go away.