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

Like • Show 0 Likes0
Comment • 6

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!

No one else has this question

Outcomes

philmodjunk Feb 18, 2013 3:34 PM

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.

Actions

FileKraft Feb 22, 2013 12:33 PM

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)

Actions

philmodjunk Feb 22, 2013 1:47 PM

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.

Actions

FileKraft Feb 22, 2013 2:03 PM

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.

Actions

philmodjunk Feb 26, 2013 12:12 PM

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.

Actions

FileKraft Feb 27, 2013 9:22 AM

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 ..

Actions

6 Replies

philmodjunk Feb 18, 2013 3:34 PM
Mark Correct
Correct Answer
     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 Likes0
Actions
FileKraft Feb 22, 2013 12:33 PM
Mark Correct
Correct Answer
     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 Likes0
Actions
philmodjunk Feb 22, 2013 1:47 PM
Mark Correct
Correct Answer
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 Likes0
Actions
FileKraft Feb 22, 2013 2:03 PM
Mark Correct
Correct Answer
     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 Likes0
Actions
philmodjunk Feb 26, 2013 12:12 PM
Mark Correct
Correct Answer
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 Likes0
Actions
FileKraft Feb 27, 2013 9:22 AM
Mark Correct
Correct Answer
     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 Likes0
Actions

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

Summary

Product

Version

Operating system version

Description of the issue

Steps to reproduce the problem

Expected result

Actual result

Exact text of any error message(s) that appear

Configuration information

Workaround

Outcomes

Related Content

Recommended Content