Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dynamic RLS Help

Hi All,   Im an RLS noob so to speak and trying to figure things out, so I have built a Security table something like this:   Email: Account: Region Country: [email protected] Apple EURO...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks so much for your reply,

 

I just tried this as

 

[Account]
IN CALCULATETABLE (
VALUES ( SECURITY[Account] ),
FILTER (
ALL ( SECURITY ),
SECURITY[Email] = USERPRINCIPALNAME()
&& SECURITY[Account] <> BLANK ()
)
)

 

and the table still stays filtered? (doesnt work as an = either sadly 😞

vik0810's avatar
vik0810
Icon for Resolver V rankResolver V
6 years ago

Anonymous , as far as I understand, your intention is not to filter at all, if the account is empty. You have to use then logical OR instead of AND.

 

 

 

[Account] IN
CALCULATETABLE (
    VALUES ( SECURITY[Account] ),
    FILTER (
        ALL ( SECURITY ),
        SECURITY[Email] = USERPRINCIPALNAME ()
            || ISBLANK(SECURITY[Account])
    )
)

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks vik0810 

     

    That returns nothing at all though, What I want to happen is the filter to basically leave everything UNFILTERED. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Im starting to wonder is what im hoping unrealistic / unachievable using RLS?

      • v-yuta-msft's avatar
        v-yuta-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Anonymous ,

         

        Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.

         

        Regards,

        Jimmy Tao