RLS related to active directory

[bapt69]

Hi everyone,

I wanna create RLS with the Active Directory.

I got an active link between the Group (from AD, with "etablissement_id" related) and my table "etablissement" (with pk etablissement_id). There is a related table between users and groups and each group equal 1 "etablissement" (like a BU as well).

On one sheet, all is good and the filters are good. On the other ones, none filtrering isactivated...I don't know why...

Relationships :

The sheet which is working :

The sheet which is not working ("etablissement_nom_court" is comin from AD and "Etablissement" is cmin the Table "d_etablissement") :

Thank you all!!

[bapt69 · Accepted solution]

I used USERELATIONSHIP which is a bad idea.....

I use INTERSECT instead of. All is workin! (and created a relationship between d_etablissement and correspondance)

[bapt69]

little add 😉 

I made this RLS :