I have a dataset that contains a column of values intended to match against an RLS tag i.e. for anonymous users passed across via an embed. When I render a single value in that column e.g. Column: Region(s), Value: ‘Southern’ and then submit the string ‘Southern’ via an anonymous tag value the tag-based RLS filters AOK.
When I produce a multi-value column using the nominated delimiter, a comma, so e.g. Column: Region(s), Value: ‘Southern,Central,Western’ the tag-based RLS fails to recognise ‘Southern’ as a Key value contained within that column.
I have also tried formatting the key column values in inverted commas e.g.: ‘“Southern”,“Central”,“Western”’ but that also fails.
What am I doing wrong?
Unfortunately, this video steps through a User-based RLS scenario. My scenario is a Tag-based RLS scenario. User tags are set from a dashboard embed passing through a lambda where the tag values are set. So I am afraid that demo does not help me at all. Sorry.
Hi,
Maybe this blog can give you some ideas? It is related to your specific use case ans uses multi values for the embeddig.
Hope this helps!
1 Like
Okay, so in that example multiple values are submitted against a single value in the column. In my scenario a single value is submitted against a column containing multiple values with the expectation that if the tag column contains the single value in its comma-separated list that it will match.
Is this not a valid scenario for an RLS tag column?
Can you share an example of data and what you expect? I fail to understand your use case.
In RLS, the value of each row in the column used is checked against the list, if the value in the row matches with one of the values in the list then the row data is available to be shown.
Yeah, no I got the direction of the delimiter wrong. I wanted to be able to take a UserId and produce a column for tag matching with multiple userIds in the column and if the UserId submitted matched one of the UserIds in the column for the row to show.
Annoying as there’s no other easy way to achieve the objective but at least I’m clear on what it is I’m looking to do now.
