Forum Discussion

victoria_g06's avatar
victoria_g06
Helper I
9 months ago
Solved

RLS error Join Paths are expected to Form a Tree

Hi everyone, I have a tricky model, I have and need two ways to filter invoices but am getting the error:

Join paths are expected to form a tree, but the table 'Shared_InvoiceHeader' has two join paths to table 'Master_Company'.

Shared_Branch is needed as it has unique combinations of Branch ID's and names,

Master_BranchSetMapping has multiple Branch IDs connected to a code to group them together. EG Group 1 has 10 Branch ID's.

I dont think I can join the two tables together as the Shared_Branch table has different systems Eg A, B that dont match to BranchSetMapping

All the visuals works until I need to set RLS and I use "View As" a role. Then the above issue happens. I have RLS on the the Masetr_Company table

  • For anyone looking - I think I have fixed it with this relationship sequence. I have tested some numbers and they are matching to the source. 

1 Reply

  • For anyone looking - I think I have fixed it with this relationship sequence. I have tested some numbers and they are matching to the source.