Hello,
I have a lot of transaction Saved Searches in a client Account that use fields from the JOIN with current user (User Fields...).
For example, I have criteria that filters data based on a property of the currently logged in user. One of those filters is Location of the user.
The problem is that whenever a user decides to restrict his view by subsidiary (his role does have permission for that subsidiary, as he is assigned to the top level subsidiary) any saved search containing a JOIN to the currently logged in user fails. No results are returned. I am sure that actually there are results because I run the exact saved search without Restrict View but filter the results by subsidiary from the Criteria tab instead. This way I get the proper results.
I also noticed that restricting the view to the Subsidiary where the current user belongs to works properly.
So, the problem appears only when restricting by a subsidiary different from user's subsidiary.
Are you familiar with such behavior and could you propose a workaround?
Thank you.