4 Replies Latest reply on Jul 18, 2012 9:30 AM by ThomasStaehli

    FM12.0v2 Portal filtering issue

    ThomasStaehli

      Summary

      FM12.0v2 Portal filtering issue

      Version

      12.0v2

      Operating system version

      windows 7, OSX Lion

      Description of the issue

      the following portal filter doesn't work on FM 12.0v2 : Amount ≠ 0

      The bug only occurs on a hosted solution (works fine with a local file)

      It works perfectly fine with 12.0v1 client

      Check this post for the details and the test files

      https://fmdev.filemaker.com/message/88404#88404

      Steps to reproduce the problem

      1) I created 2 files (1 interface, 1 data). In the data file I have 2 tables, enrollment and payment linked like this:

      enrollment::ID <- -> payment::enrollmentID

      2) In the interface file I created a layout based on enrollment with a portal based on payment

      3) In the portal option I added this filter: payment::Amount ≠ 0

      Then try the following:

      - open localy with fm12.0v2
      - upload to a FM server and open it with fm12.0v2
      - upload to a FM server and open it with fm12.0v1

      Expected result

      The records with an amount different from 0 should appear

      Actual result

      Nothing appears in the following situation:

      hosted database opened with FM 12.0v2 client

      Workaround

      split the condition in 2 (amount > 0 or amount < 0)