Can i create an interactive filter on a users manager

[Graham Cameron]

I am setting up reports on users for a dashboard and i have asked if i could put in an interactive filter in for the user manager.

I thought this would be a simple reference Interactive filter but it doesnt allow me to create it.

The idea is i select a manager from the reference list and it shows me all the people that this person is the manager of. I am probably missing something simple but i cannot see to work it out. I cannot find anything online either about some who has worked this out or even asked this question. Is this possible?

[Michael Fry1]

Can you do something like this:

[Adam Stout]

If that isn't what you are looking for, try a cascading interactive filter which would have you select a manager, and then the people working for them.

[Graham Cameron]

Hi All

Thanks for your help but i think i may have solved this one. I created a reference interactive filter which references the sys_user table.

Then for the filter reference i just used the sys_user>manager field of which ever table i want to use. Be it the Customer manager or the assigned to manager depending on the results i need.

So for assigned to manager i could use incident>assigned to>manager

Or for customer manager i could use incident>customer>manager

Obviously i would have to set up separate interactive filters for those 2 scenarios, as for any incident its unlikely the manager of the customer is going to also be the manager of the assigned to.