Forum Discussion
RLS in Chained Datasets
Hi lbendlin
Let me try and give a bit more detail, we use this report emdeded in our Customer Portal, there is currently a report called PEPI - NOHH which is embeded and has been in use for a number fo years.
The PEPI-NOHH model has the following RLS filter
| [CompanyID] = value(username()) || [HQID] = value(username()) || [REGIONID] = value(username()) |
The Username() is passed in as an integer value by our portal when the report is loaded.
I am developing a new report to replace the existing, using data from both the PEPI - NOHH Model and the HH Data 2 Model.
If i log into our Portal as as user the PEPI - NOHH tables are not filtrering down based on the logic in the RLS filter on PEPI - NOHH.
on that basis it appers the RLS of the "other models" is not being utilized
any thoughts would be most appreciated
You seem to be passing a userid that has "full access" on that RLS.
