6 Replies Latest reply on Feb 27, 2013 9:22 AM by FileKraft

    portal filtering and sorting  don't work if allow creation of related records is turned on

    FileKraft

      Summary

      portal filtering and sorting  don't work if allow creation of related records is turned on

      Product

      FileMaker Pro

      Version

      12v3

      Operating system version

      MAC WIN

      Description of the issue

      create a portal
      use a relationship with allow creation of related records on
      turn on filtering - use a dummy predicate always true
      filtering and sorting doesn't work if new records are added to portal
      - sorting works if records are open until newly records appear

      Steps to reproduce the problem

      create a portal
      use a relationship with allow creation of related records on
      turn on filtering - use a dummy predicate always true
      filtering and sorting doesn't work if new records are added to portal
      - sorting works if records are open until newly records appear

      Expected result

      sorting and filtering works as expected independent of record open state of all records within portal

      Actual result

      sorting stops working as soon as records in portal show up with record open state 1
      filter turned on breaks all calcs in custom function scanning over all portal rows using recursive custom function with getnthrecord ..

      Exact text of any error message(s) that appear

      no error - just no filtering or sorting takes place

      Configuration information

      no plug ins - file standalone - or on server -same issue

      Workaround

      no workaround possible - because portal with allow creation of related records is the only way to implement transactional behavior.

      PLEASE FIX!