5 Replies Latest reply on Mar 10, 2010 8:32 AM by SFWidescreen

    Valid Criteria Error on Instant Web Publishing

    SFWidescreen

      Summary

      Valid Criteria Error on Instant Web Publishing

      Description of the issue

      FileMaker Product(s) involved:FileMaker Pro 9.0v3Operating System(s) involved:Mac 10.6.2Detailed description of the issue:I have published a database using instant web publishing.  When I perform a find using the web interface using checkboxes on some fields I get a dialog box that says "There are no valid criteria in this request. Type a valid request before clicking Perform Find."-If I perform the same find using the FileMaker interface, it returns records.-There are other fields in the same layout that are displayed as checkboxes but function properly.Exact steps to reproduce the issue:Open a web interface to the FM Database. Enter 'Find' mode by clicking the magnifying glassSelect a check box in the field you're searchingClick "Perform Find"Expected Result:A found set of recordsActual Result:On some fields there is an error message that the criteria is not valid. The same search through the FM interface returns records.Exact text of any error message(s) that appeared:There are no valid criteria in this request. Type a valid request before clicking Perform Find.Any additional configuration information/troubleshooting that is relevant to the issue:Changing the checkbox value list to a list from a field that works doesn't eliminate the error message.The field is text and indexed. (other indexed text fields do not generate the error).The error occurs in Firefox and Safari browsers.Any workarounds that you have found:If I perform the same find on the same field with the same criteria in the same layout with the field displayed as a text box rather than a checkbox, it returns records.  

        • 1. Re: Valid Criteria Error on Instant Web Publishing
          TSGal

          SFWidescreen:

           

          Thank you for your post.

           

          On the one Snow Leopard machine I have, I only have FileMaker Pro 10 installed, and it does not exhibit this behavior using Safari and Firefox on a Mac, and Safari, Firefox and Internet Explorer on Windows.  I will try to find and install FileMaker Pro 9 this afternoon.

           

          In the mean time, I would like to see if this problem exists on your computer with a new database file.  That is, create a new database file with one text field, format the text field as a checkbox with values "Yes" and "No".  Enter one record, turn on Instant Web Publishing, and enter a couple of records.  Access the database file via Instant Web Publishing, and see if you can find records.  If you are able to find records, then either your original layout is damaged, or the file is corrupt.  Try creating a new layout with the checkbox field and see if you are able to find records.

           

          Please keep me posted with any progress.

           

          TSGal

          FileMaker, Inc.

          • 2. Re: Valid Criteria Error on Instant Web Publishing
            SFWidescreen

            I've explored this some more and I can now duplicate it every time.  I think you'll be able to duplicate as well.  Here are the steps:

             

            1. Create a new FM database with one text field, "Test"
            2. Create a layout with the field and have it display as a checkbox set with the values "Yes" and "No"
            3. Create at least one record with the value "Yes"
            4. Publish the database with Instant Web Publishing
            5. Access the database over the web
            6. Perform a find on "Yes"
            7. Notice that you get the expected result, the record you created
            8. Go back to FM and add another instance of the same field, "Test" on the same layout.  This time have it display as an Edit Box.  You now have the same two fields on the layout, one displaying as a Checkbox Set and one as an Edit Box
            9. Go back to the web view of the database and perform the same find, using the checkbox set instance of the field
            10. Notice that you get the "Valid Criteria" Message
            11. Try the identical find again using the Edit Box instance of the field, searching for the value "Yes"
            12. Notice that you get the expected result

            The moral of the story: If you have both a Checkbox Set and an Edit Box version of the same field in the same layout, you can't perform searches using the Checkbox Set version using Instant Web Publishing.  Let me know if you need me to send the sample database.

            • 3. Re: Valid Criteria Error on Instant Web Publishing
              TSGal

              SFWidescreen:

               

              Thank you for the detailed information.  I was able to replicate the problem.

               

              Here are my findings which I have also forwarded to Development and Software Quality Assurance (Testing) departments for review.

               

              The same problem occurs if the field is also set to display as a radio button.

               

              If the checkbox field appears below the Edit box field, the problem still occurs.

               

              If you change the format of the Edit box field to a checkbox field, and change the checkbox field to an Edit box, the problem does not occur.

               

              Without getting into a lot of detail, this problem exists if a field is formatted as a checkbox or radio button, and a second occurrence of the field is added to the layout formatted as an Edit box.  If a field is formatted as an Edit box, and a second occurrence of the field is added to the layout formatted as either checkbox or radio button, the problem does not occur.

               

              Therefore, to work around this problem, change your original instance of the field to an Edit Box, and change the second occurrence to a checkbox field.  You can then switch the location of the fields.

               

              Let me know if you run into any difficulty or need clarification.

               

              TSGal

              FileMaker, Inc.

              • 4. Re: Valid Criteria Error on Instant Web Publishing
                TSGal

                SFWidescreen:

                 

                I forgot to mention....

                 

                This problem also occurs in FileMaker Pro 10 and FileMaker Pro 11.

                 

                TSGal

                FileMaker, Inc.

                • 5. Re: Valid Criteria Error on Instant Web Publishing
                  SFWidescreen

                  Thank you for the confirmation and the workaround, TSGal.