0 Replies Latest reply on Jul 28, 2012 4:10 AM by FileKraft

    portal filtering of uncommitted recrods can be toggled (show or unshow filtered) in fm11 but not in...

    FileKraft

      Summary

      portal filtering of uncommitted recrods can be toggled (show or unshow filtered) in fm11 but not in fm12

      Product

      FileMaker Pro

      Version

      fm12v2

      Operating system version

      OSX 10.7.4

      Description of the issue

      in fm11 i use Refresh & Flush to display changed filtering of uncommitted portal records - in fm12 the filter works after committing only the Refresh & Flush doesn't change the display.

      Steps to reproduce the problem

      1. create a portal  based on a relationship with allow creation of related records

      2. use a script trigger to commit only by hitting a button which sets a flag the OnCommit trigger tests for and resets it when committing

      3. create a filter predicate in the portal setup to be true if either the global filter field is empty of the parent record or the field in the child record postion function is true ( > 0 )

      4.  create a on validation or save trigger to refresh & flush when the filtered global field changes the filter is testing on by checking with position function '

      Expected result

      to display independently of record open state the portal filtering when changing the filter content

      Actual result

      no change when filtering while uncommitted

      Configuration information

      file is standalone

      Workaround

      none - portals with allow creation of related records are the only way to implement transactional functionality supported within filemaker's commit logic.

      also filtering here is the only way to turn on / off a hierarchical structure with uncommitted records in fm11 but not infm12- it works displaying the data nicely but the math fails in fm11.

      thank you !

      (i have a demo file if you want )