I have the user attribute
email from Okta.
Can I set it us as a parameterized filter, and then use the value to join in other tables -- and then use columns from the joined in tables as access filters?
Here is the use case:
I have tables with a foreign key
email. I can join in tables to get the multiple locations to which that email address is entitled to see data. I would like to leverage the incoming value for
email to constrain the joins and get be a series of values for, say, location_id so there I can do a
where in ( list_of_location_ids )
It seems that this is not quite there.