Jump to content
Sign in to follow this  
Rank Beginner

Sort portal records?

Recommended Posts

I have a simple Filemaker Pro 8.5 database. It has students' data in one table and details about the classes they take in a second table.

A portal lets me see the student's class records. I want those records to display in chronological order with the most recent class showing at the top of the page.

When I set up the portal, I checked "Sort portal records" in the Portal Setup dialog box, specifying to sort in descending order by the field "Start Date."

Unfortunately, the portals instead always show the classes taken in the order in which those records were entered and I can't make the records in the portal sort by the "Start Date" field.

Was I wrong about what this part of the Portal Set up dialog box was for? Might there be something else in my database that might over ride those settings?

Has anything like this happened to anyone else?

Thank you in advance for any suggestions.

Share this post

Link to post
Share on other sites

Hi Rank Beginner,

Portal sorts override even relationship sorts so it should be working. Are you sure the start date is type Date and not text (open your field definitions to check)? Also check your portal table occurrence name (look at the bottom row of the portal while in layout mode to find the table occurrence name). Then verify that the fields inside are also based upon that same name (double-click the StartDate field to bring up field control).

Also, in your sort dialog, be sure there is nothing selected in Reorder based upon Summary or Override Field Language (at the bottom).

LaRetta :wink2:

Share this post

Link to post
Share on other sites

LaRetta, I sure appreciate your check list. I finally had time last night to run through all those alternatives, and at least I had all those parts right.

What I did discover, however, is this:

I have several tables: Student Info; Enrollment Info and Class Info.

Most of what shows up in the unsortable portal comes from the Enrollment Info table. The Start Date field, however, is from the Class Info table.

I have a Start Date field in both tables, but when I joined them, it really goofed up the records the portal displays big time. I am going to go read up on portals, tables and table occurrences to see if there is a solution. I really, really need those class start dates displayed in reverse chronological order!

Thanks for your suggestions--they gave me a starting place!

Share this post

Link to post
Share on other sites

If the class Table occurrence (TO) is related to the Enrollment TO, you can choose to add a sort by the Class TO by temporarily changing the portal to reflect the Class TO and then after add the sort criteria, going back to the orig Enrollment TO.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.