Sort context bleeding off portal onto chart
Operating system version
12 Ov 3
Description of the issue
One half of a self join table relates to a subordinate data table. On the layout for this top half of the join pair I have a portal pulling related records off the bottom half of the join. This portal has a sort order set by the portal which I will call sort order P. In addition I have a chart which portrays the subordinate table which is related to the top half of the join set. The chart is set to show a related value for the found set from the top join TO and sorts to order W. I put a button on the portal which does a record select through a go to related record using the same layout and the bottom half of the join. The chart ADOPTS the protal's sort order when the go to related record script step executes. When a button located on the layout proper executes another script with an identical go to related record command, the chart goes back to its correct sort order that I both defined in the relationship box, and on the layout itself.
How can I get the chart to stop adopting the portal sort order?