Forum Discussion
Alternative to UserRelationship
Anonymous ,
I've tried duplicating the table and setting two active relationships, but my main problem is that due to the cross-filtering on the active relationships my data is filtered and the numbers are no longer accurate. An inactive relationship does not fitler my data, so UserRelationship was ideal.
Yes, RLS will not be affected by inactive relationship. So I'm afraid the only is to reconstruct the table relationship between the tables without using cross-filtering.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous ,
I've tried duplicating the table and setting two active relationships, but my main problem is that due to the cross-filtering on the active relationships my data is filtered and the numbers are no longer accurate. An inactive relationship does not fitler my data, so UserRelationship was ideal.
Yes, RLS will not be affected by inactive relationship. So I'm afraid the only is to reconstruct the table relationship between the tables without using cross-filtering.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.