is there a way to access parent attribute value in child entity without lookup in row level security XPath rule?
Parent Entity E1 with columns E1C1(Id) and E1C2 and child Entity E2 with columns E2C1(refE1C1Id) and E2C2. Now I have simple screen based on datastructure with E1 as parent and E2 as child. I need row level security rule on E2, which will decide if add row on child screen is allowed based on value in column E1C2 from master Entity E1.
Is there any performance impact when datastructure is modified that way? For instance - it adds one more SQL select to each child row to get the parent value or only one more SQL select for whole child entity?