Filter relationship with a global- and a calc field?
I took me some time to find out that I can't filter a relationship with a global field and calc field.
But my problem is:
I have a self-join relationship which I need to filter data:
Table A: payowner_OBJ / Table B: payowner_OBJ_selfjoin
_pkObject X _pkObject
xStatusNotifySaleOwner (=Open) = StatusNotifySaleOwner_c
StatusNotifySaleOwner_c is a calc field which collects data from a related portal:
Case (Stat_NotifySaleOwner_lastrow_c = "Not Notified" OR Stat_NotifySaleOwner_lastrow_c = "Reported" OR Stat_NotifySaleOwner_lastrow_c = "Billed"; "Open")
What is the best way to solve the problem (for a beginner in scripting) with the calc field?