AnsweredAssumed Answered

Finds fail with relationships where value ≠ empty value

Question asked by smith7180 on Nov 1, 2018
Latest reply on Nov 1, 2018 by TSGal

Observe the following relationship.

Screen Shot 2018-11-01 at 2.34.23 AM.png


"Constant_one" is always equal to one, and "empty" is always empty. The relationship is always valid. As expected, a portal from primary to foreign will display every foreign record for each primary record.


However a search for all primary records that have any foreign records will always fail.


See this screenshot from the attached sample file:

Screen Shot 2018-11-01 at 2.34.44 AM.png


Thanks for your time.