6 Replies Latest reply on Jul 18, 2017 10:56 AM by philmodjunk

    Find returns no records while there are records meet the searching criteria

    liyangao

      On Mac 10.10.3 and FileMaker Pro 15, for users with the customized privilege set of Data Entry Only Audit, the FIND button was returning wrong result. When we search on a record we saw in the database, FIND will return no record. What can be wrong? We do FIND on the fields all the time.

      Thank you for your help!

      Liyan

        • 1. Re: Find returns no records while there are records meet the searching criteria
          TomHays

          For us to provide useful help, please be very specific on how you are carrying out your search including details of what you enter into the field(s) during the search and what type of fields those are.

           

          -Tom

          • 2. Re: Find returns no records while there are records meet the searching criteria
            philmodjunk

            In addition, if you use a full access account to open the file and then do the same find with exactly the same criteria, do you get the same problem?

            • 3. Re: Find returns no records while there are records meet the searching criteria
              liyangao

              Thank you and Tom for your responses.

               

              The search is very straightforward. I tried to search on a number field of DBID and another text field for Name by clicking the FIND icon and the field with 1234 for DBID and Smith for Name.  It returned not found for a record we knew that it was there.

               

              If I use a full access account to open the file and do the same find with the exactly the same criteria, I found the record as usual.

               

              The wrong results happened to users with Data Entry Only Audit privilege after I added the customized privilege with the Audit Log plugin. It occured to me that it may be caused by the audit log. But the same implementation worked for other database but not this one.

               

              I really appreciate your insight and suggestions!

              Liyan

              • 4. Re: Find returns no records while there are records meet the searching criteria
                philmodjunk

                I don't know for sure if this is the reason for your Find failing to bring up that record as I can't examine your  file, but the following is consistent with the results that you report:

                 

                If you use Manage | Security to set up Record Level Access Control, any Find that you perform will automatically omit any record that the user is not allowed to view.

                 

                Try using the limited access account to Show All Records. Do some of the records come up coveted with a "no access" screen? That would confirm that RLA has been set up for this privilege set.

                1 of 1 people found this helpful
                • 5. Re: Find returns no records while there are records meet the searching criteria
                  liyangao

                  Thank you so much for your pointer.

                   

                  Yes, I used Manage | Security | Privilege Sets | Custom Record privileges. For each table, VIEW, EDIT and DELETE were set to be limited for fmDataGuard 3 to log the actions. When I set all table View to be yes, users with Data Entry Only Audit privilege will be able to use FIND correctly. In the login script triggered by the event of OnFirstWindowOpen, I added the sentence to set $$LogViews to be True in order to put record views log in the audit log file.

                   

                  Another way for FIND to work properly is to remove the setting of $$logViews to be True in the login script and set all table VIEW to be limited by calling DataGaurd_PostView when $$LogViews=True. This way VIEW will not be recorded in audit log most of the time.

                   

                  When $$LogViews is set to be True in login script and VIEW for tables is set to be limited in Custom Record privileges, the FIND function will return NO RECORD for any search we knew have records satisfying the FIND criteria.

                   

                  I am still a little puzzled by the FIND result. All the records with Limited VIEW only for logging the event, how come all the records were automatically omitted from being viewed?  Any insight?

                  • 6. Re: Find returns no records while there are records meet the searching criteria
                    philmodjunk

                    I would need to see the data in the fields that might affect access for the record in question and also the specific settings for viewing records specified for the privilege set in question.