Interactive filter with multiple references to the same reference table but for diff reference field

[Kshitija1]

I am trying to create an interactive filter for all the managers. We have 4 hierarchy of managers. Based upon the manager selected from the interactive filter, the report should display the list of dashboards created by subordinates. 

For this, I am fetching a list of managers from sys_user table. and created 'interactive filter references' with reference table 'pa_dashboards' for reference field 'owner.manager'. I want to fetch the data of owner.manager.manager and owner.manager.manager.manager and so on using single interactive filter. I tried creating multiple references for the same reference table i.e. pa_dashboard but its not working. Is there any way to create multiple references for the same reference table on different references fields? is there any other approach to resolve this?

[Community Alums]

@Kshitija1 please follow below hierarchy to achieve your requirement,

1. First drop down in filter will display top level i.e. owner.m.m.m.m = user.m.m.m.m

2 second drop down would be one down i.e. user/owner.m.m.m and here and so on so.

Please remember each level from top to button in filter hierarchy must be matching for example if user.m.m then dashboard filter owner.m.m

I believe you are using cascading filter.

Hope this will help you  

[Palak Gupta]

Hi @Kshitija1 ,

Are you dot walking on List fields? Could you share the screenshots of the dot walking which your are taking.

Regards,

Palak

[Kshitija1]

Hi Palak,

I am trying to implement below functionality.

I have created a Managers - level 1 filter. I am trying to create multiple 'Interactive Filter references' on pa_dashboards for reference fields owner.manager, owner.manager.manager so that I do not have to create 2 separate filters. Currently, the reports following this filter is showing 0 records. It seems that I cant create multiple references for the same table.

I tried implementing this functionality using cascading filter but even that is not working properly.

[Tsura Andreeva]

Can you share the interactive filter you have created so we can help you troubleshoot