RLS from database

[harshagraj]

Hello all,
I have report which has RLS defined for "Function". In the Manage Roles i have created 4 roles 
[FUNCTION_NAME] = "Engineering"
[FUNCTION_NAME] = "ISC"
[FUNCTION_NAME] = "Procurement"
[FUNCTION_NAME] = "Quality" and have defined AD groups respectively in service and it works fine.
Now how will i define for an AD group who can access all functions?
Is it [FUNCTION_NAME] =TRUE()
Kinldy help @amitchandak 

[jdbuchanan71]

You would create a 5th role with no filters on it then assign users that should see all functions to that role.

[harshagraj]

Hi @jdbuchanan71 thank you but how would i create that? is it just [FUNCTION_NAME]?

[jdbuchanan71 · Accepted solution]

You can create a role that has no filters assiged or, if you want you can just add TRUE() to the table that holds the Function_Name field which would look something like this:

[harshagraj]

Thanks a lot! this works