AnsweredAssumed Answered

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

Question asked by FileKraft on Feb 18, 2013
Latest reply on Feb 27, 2013 by 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!

Outcomes