mercator

Portal for relationship using "ORed expressions"

Discussion created by mercator on Jun 6, 2016
Latest reply on Jun 7, 2016 by user19752

I basically have two tables - with some more attributes as actually shown below:

Parent(id, A,B)

Child(id, A, B, C)

 

For Parent, I would like to show a portal with the Child records, where the relationship between the is a set of "ORed" expressions, e.g. the following:

Parent.A = Child.A OR Parent.B = Child.B OR ((Parent.A - Parent.B)= Child.A)

 

Is there a way of doing this in an intelligent way?

Outcomes