2 Replies Latest reply on May 23, 2014 1:31 PM by TSGal

    Request criteria  bug report

    YouriRICHER

      Summary

      Request criteria  bug report

      Product

      FileMaker Pro

      Version

      13.0V3

      Operating system version

      Windows 7

      Description of the issue

      Bug when a filter is linked to a script which sorts the variable in this type:

      $$Variable*

      In my case, I put a filter to sort paid invoices, and non paid invoices, however, non paid invoices are displayed even if I chose the paid invoices filter.

      Steps to reproduce the problem

      See the DD Catering invoice

      Expected result

      Only "Paid invoices" should appear

      Actual result

      Non paid AND paid invoices appears

      Workaround

      related to the template

      IssueEx.png

        • 1. Re: Request criteria  bug report
          philmodjunk

               Exactly how did you use $$Variable* ?

               To perform a find? In a Perform Find step that used $$Variable* as stored find criteria.

               Stored find criteria cannot be set up as expressions with operators to be evaluated. They should be either literal criteria or just a simple Variable with no added operators or other text.

               But you can use a scripted find that uses such an expression in a set field step:

               Enter Find Mode [] ---> clear the pause check box
               Set Field [YourTable::YourField ; $$Variable & "*" ]
               Perform Find[]

               For more examples of scripted finds set up in this format, see: Scripted Find Examples

          • 2. Re: Request criteria  bug report
            TSGal

                 Youri RICHER:

                 Thank you for your post.

                 As an additional note to PhilModJunk, if the filter is set to find "Payée", this will find records with "Payée" anywhere in the field, including "Non Payée" records.

                 TSGal
                 FileMaker, Inc.