Hi all, I have a portal that is based on a relationship as follows
Left side is a global field with a list of recordIDs:
"ShowIDs"
eg.
3
2
1
etc.
Right hand side is where that field is related to the foreign ID.
works perfect but is there any way of sorting that relationship to display the records in the same order as the IDs appear in the left side field.
So above they would be sorted by record ID
3,2,1
To sort at relationship level you choose the Sort option on the non-global side of the relationship. When you select this option it opens up a standard Sort Records dialog where you can specify whatever option(s) you require.
An alternative if you only want to sort a single portal view of the related records is to just sort that portal.
Yes it is the later type of sorting you mention and I figured it could be difficult, I will have to build a method of sorting portals on demand.
i believe this is still a feature that needs a few workarounds?
thanks
Yes, there is no built in feature for sorting a portal dynamically.
Two basic approaches can be searched out of this forum or other resources:
Define an unstored calculation field that returns the value of different fields as determined by the value of a global sort field or variable. Set your portal to be sorted on that calculation field. Result type has to be text and number values need padding with leading zeroes in order to get the correct sorted order.
Set up several different copies of the same portal, each with a different sort order, each on a different panel of a tab or slide control. The tab or slide control can be invisible to the user with a script using go to object to bring a particular panel with it's sorted portal into view.
There are different pro's and con's for each method.
If you want them sorted in descending order as shown in your example, then yes, you can double click a relationship line to open a dialog where you can specify a sort order for related records. A portal can also have a specified sort order.
But if the ID's listed might be arranged into an arbitrary order in the global field and you want the related records to match that arbitrary order, then no, this is not possible as a relationship property. The order of the listed IDs in the global have no effect on the order of the records in the related table.