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 Feb 18, 2013 7:17 AM

Summary

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

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!

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

philmodjunk Feb 18, 2013 3:34 PM (in response to FileKraft)

     Using Windows XP, I cannot reproduce this in FileMaker 12.0v3

     In my Known Bugs List Database, I have a portal on the bug report layout that lists Categories. It's set to sort by category in ascending order and allow creation is also set. It works just fine. I can select a value in the "add" row of the portal and when I click the layout background to commit the record the portal updates to show the category records in correct ascending order.

     I then went into layout mode and entered an "always true" portal filter expression:

     True

     The portal behavior did not change.

     It then tried this always true filter expression:

     Not IsEmpty ( Categories::BugID )

     and again the portal remained fully functional.

     I'm using a classic themed layout so if you are not, that may be a difference here.
Like Show 0 Likes(0)

Actions
2. Re: portal filtering and sorting don't work if allow creation of related records is turned on

FileKraft Feb 22, 2013 12:33 PM (in response to FileKraft)

     sorry i wasn't more specific - here is the discussion where i tried to outline it further.

     thanx for looking into this.



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



     (i might provide a demo file soon)
Like Show 0 Likes(0)

Actions
3. Re: portal filtering and sorting don't work if allow creation of related records is turned on

philmodjunk Feb 22, 2013 1:47 PM (in response to FileKraft)

Well having read the technet discussion it's still not clear to me what you want to have happen differently. Thoughout that post, you describe the process as "broken" but do not go into detail as to how, exactly, it was "broken" for you. This lack of detail will handicap any efforts by FileMaker techs to reproduce the issue you are reporting.
Like Show 0 Likes(0)

Actions
4. Re: portal filtering and sorting don't work if allow creation of related records is turned on

FileKraft Feb 22, 2013 2:03 PM (in response to FileKraft)

     it is the first phrase where i explain:. "setting the relationship to allow creation of related records breaks portal-filtering and portal-sorting as soon as you enter a new line."

     so what is so difficult to understand here? by breaking i do imply - sorting stops and filtering stops.
Like Show 0 Likes(0)

Actions
5. Re: portal filtering and sorting don't work if allow creation of related records is turned on

philmodjunk Feb 26, 2013 12:12 PM (in response to FileKraft)

Since this does not happen on my system when I try to replicate the issue. filtering and sorting still works. Thus, I am trying to identify exactly what is different between what you and I are doing.
Like Show 0 Likes(0)

Actions
6. Re: portal filtering and sorting don't work if allow creation of related records is turned on

FileKraft Feb 27, 2013 9:22 AM (in response to FileKraft)

     do you have mixed records in your portal - mixed regarding recordOpenState (0, 1, 2)

     do you ccontrol committing via an OnCommmitTrigger ?



     i will provide shortly a demo file - thanx god someone savvy from GB could confirm it on the mentioned discussion ..

     i experience a lot of weird behavior within portals as soon as the record open count > 0 ..
Like Show 0 Likes(0)

Actions

Go to original post