1 Reply Latest reply on Apr 9, 2012 10:02 AM by TSGal

    Portal filtering: <> versus  ≠ operator (not equals)

    JeroenAarts

      Summary

      Portal filtering: <> versus  ≠ operator (not equals)

      Product

      FileMaker Pro

      Version

      12

      Operating system version

      Mac OS 10.6.8

      Description of the issue

      Using the <> notation ('not equals' operator, e.g. Invoices::Status <> 3) no longer works in portal filters. It does work in other expressions, for instance in the data viewer. This is inconsistent I think.

      Steps to reproduce the problem

      Create a portal, select 'Filter portal records' and use <> in any expression.

      Expected result

      Not equals evaluation result

      Actual result

      Less than evaluation result

      Exact text of any error message(s) that appear

      No message

      Workaround

      Use  ≠ instead of <> notation