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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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