my app has some tables that need security filters that are not related to the useremail() ,
i have a table called “users table” , it contains the “Email” and “company key”
I’m trying to get the security filter to look at the “useremail()” then ‘Users table’, “email” = “Company Key”
so that way when a user opens the “equipment” table and their user has a “company key” attached they should be able to view all equipment for that company by “company key”
I assume your equipment table has a [company] column, referencing a company record.
I also assume you are already filtering out the company table with security filters as well.
If so, you can simply put this for the security filter on equipment:
ISNOTBLANK( [company].[company key column] )
i don’t have any other filters or slice row filters yet, this is the first one.
3 Tables
-Users
-Company Employees
-Equipment
common columns
-Email
-Company Key
for the table “Equipment list” I would like to set the security filter to show only matching “company Key” by looking at “useremail()” then look at the table “company employees” column [Email]
>>“matching “company Key” by looking at “useremail()” then look at the table “company employees” column [Email]”
Bad idea.
Forget about that and work towards what I explained above. Filter down the company table first, then all other tables can have super easy cascading security filters.