Jump to content
Sign in to follow this  
dnice240

Sorting Portals

Recommended Posts

Hello,

I have a join portal where the majority of the fields are not in the table that the portal is searching from. That is the portal is connected to table join, and there is a field from the join table for company id; however, every other field in the portal is from the company portal.

I would like the portal to sort by a field in the company table. How can I do this? When I choose the sort option, the only choices I have are from the join table.

Thanks a lot for the help.

Edited by Guest

Share this post


Link to post
Share on other sites

this is a work around, cause FM UI for sorting portals doesn't allow you to choose other table occurrence.

All you need to do is change the portal to the relationship you wish, then edit the sort order, rinse and repeat if you have multiple relationships. Then just reassign the portal to your intended TO.

your sort order will have the TABLEOCCURANCE::FIELD for each item in the sort order, except for any fields that you directly sort on via the current relationship.

one note is if your portal can have a LOT of related records your sort time could increase possibly present the "sorting progress" dialog.

Share this post


Link to post
Share on other sites

Great tip - didn't know this one. Thanks, Stephen.

Share this post


Link to post
Share on other sites

The same procedure works too for the sort order on the Table Occurrence on the graph

Share this post


Link to post
Share on other sites

Now that's a first! ;)

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.