Filter Portal with relationships
I am trying to filter my portal with a relationship instead of actually filtering my portal.
Important to not that I have my layout setup so that it has a self-join portal using a cartesean join so that I can click a portal record (using goto related record script) and have that records content load on the layout outside of the portal.
I want to filter the portal with a calculation. I understand that you can set up a calculation field on the parent table occurrence (that has a boolean result) and join it with a global field(that has a value of 1) in the child table occurrence to accomplish a calculated filter. I have tried this but can't get it to work, it shows all records.
Any idea how to get this to work?