Report filter(Reporting Manager is the current user) is not working for me

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
 I'm trying to filter the records based on the current user. I have a field named "Employee - Reporting Manager" which is a user lookup field. In the reports filter, I have set the criteria as "Employee - Reporting Manager" is the current user. In this field, I have a value(Gayathri, A). But when I log in as this user, this particular record is not being displayed in the report. Not sure where it is going wrong.
Photo of Gayathri A

Gayathri A

  • 92 Points 75 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,758 Points 5k badge 2x thumb
Hi Gayathri,

Do one thing, please try to filter first with your name:

Employee - Reporting Manager" is equal to (Gayathri, A)

Now, you check that you are able to see the record or not?

Thanks,

Gaurav
Photo of Gayathri A

Gayathri A

  • 92 Points 75 badge 2x thumb
Hi Gaurav, Thanks for your suggestion and I did try. It is working with the static value. But not with the "is the current user". What could be the issue?
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,758 Points 5k badge 2x thumb
Did you try to test as a different user?
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,758 Points 5k badge 2x thumb
and try to display that field on the form and see if you can see the user correctly.
Photo of Gayathri A

Gayathri A

  • 92 Points 75 badge 2x thumb
Hi Gaurav, Thanks for your suggestion and I did try. It is working with the static value. But not with the "is the current user". What could be the issue?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,786 Points 50k badge 2x thumb
Does it work for other userids. Perhaps that user has two userids and you are not signing on to their actual userid correctly.