Érico - Hello all!I'm configuring a RLS rule ...
Hello all!
I'm configuring a RLS rule where each user is only able to see data relative to their company. In this case we use the company ID from our database as the ThoughtSpot group's ID. In RLS we can use two variables (ts_groups and ts_groups_int), but it isn't clear what we're getting by using ts_groups_int. Is it our company ID (which is integer) or some TS internal one?
1 Reply
ts_groups: This variable contains the list of all ThoughtSpot group names the user is a member of. These group names are always treated as strings, even if they look like numbers
ts_groups_int is automatically populated with the numeric ThoughtSpot group names that the user is a member of
Example: If your user is in a ThoughtSpot group named 12345, then:
ts_groups will contain '12345' (as a string)
ts_groups_int will contain 12345 (as an integer)