4 Replies Latest reply on May 3, 2013 12:45 AM by Fred(CH)

    Bug with finding duplicates



      Bug with finding duplicates


      FileMaker Pro



      Operating system version

      Mac OS X 10.6.8

      Description of the issue

      In find mode, FileMaker gives us the ability to type in ! (the exclamation point) in order to find duplicates on a certain field.

      This works just fine, UNLESS you choose to "Constrain Found Set" instead of "Perform Find". Then, FileMaker doesn't always work properly. In the resulting found set, SOME records will be duplicates and SOME records WILL NOT BE duplicates at all.

      So, because of this bug, there is no way to effectively search for duplicates WITHIN the current found set that you are looking at.

        • 1. Re: Bug with finding duplicates

          I think that in this context, you constrain the found set to  records that have a duplicate value matching records in the entire table instead of just that within the found set. Don't think FileMaker techs would call this a bug, but that's often simply a matter of opinion...

          So, because of this bug, there is no way to effectively search for duplicates WITHIN the current found set that you are looking at.

          You can sort your records by this field. Then records with duplicate values in the found set will be located adjacent to each other and this is a situation you can use to constrain your found set to just those records with a duplicate value if you use a script to do so...

          • 2. Re: Bug with finding duplicates

            Thanks so much, Phil... ah, yes, this seems to be another one of those grey areas where my opinions and the FileMaker techs' opinions differ! Wink

            • 3. Re: Bug with finding duplicates

                   Dear Phil,

                   I would have to agree with scotty321, this seems like a bad behavior on FileMaker's part. When contraining a  found set, wouldn't you expect to contrain your found set. regardless of the search criteria entered? Maybe the "!" operator shouldn't be allowed in contraints in order to avoid this confustion? Or better yet, allow users to check for duplicates within a found set!



              • 4. Re: Bug with finding duplicates


                     The duplicate symbol is a cool function but it do not either satisfy me at 100%, and that for one more reason : multiple [!] criterias in same request.

                     Here too, the usual AND logic is not applied ! A basic exemple is when First Name, Last Name and Address must both be similar to consider records as duplicates. You are thinking that you can just type [!] on both field but... that fails. Because they are considerated separately like in an OR logic in multiple requests.

                     That brought me to think that a better way (but yes that needs a little more work) is to deal with a dedicated T.O. that is relating orginals and duplicated. 

                     I suppose that you also had thinked about it. But If not, i am developing now a database where i use this technique and bring it rather far. That proves very reliable and comfortable for enduser to see quickly and at any time where are the duplicates of a specific record and for developer too, thus he can provide advanced duplicates-solving scripts !

                     Bye, Fred