AnsweredAssumed Answered

Filter relationship with a global- and a calc field?

Question asked by ferdinand on Aug 15, 2011
Latest reply on Aug 16, 2011 by philmodjunk

Title

Filter relationship with a global- and a calc field?

Post

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

Filter: 
_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? 

Outcomes