Self Relating table -lookup and report
So I have tried to create a table related to itself. I am maintaining a staff table which join itselfs to maintain its manager hierarchy information. Now I want to create a report based on the current...
Forum Discussion
easy, just filter the report where the manager userid "is the current user". That should be offered as a choice in the report filter.
If it's is not offered up as choice you can use the somewhat obscure legacy notation of _curuser_ to compare the userid field to (yes, with those leading and trailing underscores). Or if necessary create a field called Current User of type formula user with a formula of
User()
If it's is not offered up as choice you can use the somewhat obscure legacy notation of _curuser_ to compare the userid field to (yes, with those leading and trailing underscores). Or if necessary create a field called Current User of type formula user with a formula of
User()
Well I should re frame, the current user need not be a manager. So referencing from my earlier example. If the current user is rid 1- the report outcome should have staff rid 1,2,4.
The logic you suggest above will work only when a manager logs in and will fail for any other user.
The logic you suggest above will work only when a manager logs in and will fail for any other user.
