I have visual perspectives which display queries filtered on the LoggedIn user.
In the filter WHERE clause, when I use:
WHERE xxx.LoginName = LoggedInSystemUser.LoginName
or when I use
WHERE xxx.LoginName = LoggedInRegularUser.LoginName
the queries return no results.
When I use :
WHERE xxx.LoginName = LoggedInAccessLevelxxx.LoginName,
Example: WHERE xxx.LoginName = LoggedInEmployee.LoginName, queries return the results properly.
This causes me to create separate queries filtered for each access level that I need to show in each respective access level's visual perspective.
Is there a better way to code the where clause in a single (shared) query, so that I do not have to create separate queries for each access level?
