I have a 3-level hierarchy, where the parent top 2 parent list is selective access enabled. I want the bottom-most list to also have filtered dropdown based on its parent's selective accesses.
One way I was able to do it is by enabling selective access for the child list and enable Selective Access Boolean in the Line-Item Format while defining the list as the format for the line item. For the users they will always have some selective accesses in the top 2 parent lists, and there is no requirement to set any selective access for the last child list.
It fulfilled my target to have a filtered dropdown of the list based on selective access, but I want to know if there is any major impact of this workaround, in terms of performance or sparsity.