AnsweredAssumed Answered

Custom SQL report with organisation restrictions

Question asked by DavidHobbs Advocate on Feb 21, 2020
Latest reply on Feb 28, 2020 by Samuel

Hi,

 

We have some very useful Custom SQL Reports, but unfortunately they show all the records to everybody.  We would like to have organisation restrictions on these reports, so our users can only see there data from their own country.  Has anyone else managed to get this to work?

 

I see that Liam was able to get dynamic CIDs to work, so I wonder if anybody has been able to build a custom report that recognises which user is running the report?

 

Thanks, David

Outcomes